Re: Filemaker Server Pro / Pro Advanced Security

On Mar 8, 9:48 am, "Grip" <g...@xxxxxxxxxxxxx> wrote:
On Mar 8, 8:04 am, "musicofnote" <lce...@xxxxxxxxxxxxxxxx> wrote:



Question:

We have a suite of DBs hosted on a Mac G4 running OS 10.3.9 and
Filemaker Server Pro 7.04. It's running just peachy. Another group at
the school also has some DBs running on the same server.

Up until now, all Filemaker users have been using FMPro to access
these DBs. Guest access is turned OFF and none have either physical or
normal user access to the actual machine hosting the DBs.

Now, all our users are supposed to get Filemaker Pro Advanced 8.5
because we can get it as a subscription for the same price as the
"normal" version.

I'm concerned about any possible extended risks involved with normal
users having access to the FMPro Advanced Tools AND to sensitive data
on a FMP Server. Could they, for example damage or compromise a DB
with this version of FMP Advanced, that they otherwise couldn't, if
they stayed with the "normal" user version?

Personally, I have an uneasy feeling, giving non-developers a
developer-tool when they don't need it.

Thanks for any input in advance...

This is a bad idea.

I don't know if there'll be access to sensitive non FMP data on the
server, but the Debug Scripts tool will enable users to get themselves
into trouble, interrupting scripts, skipping data validation, If
statements regulating permissions, etc. The Data Viewer will allow
users to access data that you may not want them to.

You might be able to program around these issues, especially using
access privileges, but it could be a nightmare.

G

Upon some experimentation, I've found that the Script Debugger only
works with Full Access accounts, so less worry there. The Data Viewer
may provide the intrepid user a way into (or out of) secure areas of
the db, but it won't be easy. So maybe I was a little alarmist.

G

.

Relevant Pages

  • Re: Move 10 DBs and provide dev access thru EM?
    ... DBs open. ... "Dan Guzman" wrote: ... need to stop SQL Server. ... the process using the database files. ...
    (microsoft.public.sqlserver.security)
  • Re: Filemaker Server Pro / Pro Advanced Security
    ... Filemaker Server Pro 7.04. ... the school also has some DBs running on the same server. ... all Filemaker users have been using FMPro to access ...
    (comp.databases.filemaker)
  • Re: Moving all DBs to new machine with same name
    ... These are 2 separate machines, but which have the same exact version of SQL ... I know what is involved with renaming a server. ... I won't be renaming the server with any of these DBs I am moving attached. ... > You don't need new databases, they will be created during restore. ...
    (microsoft.public.sqlserver.server)
  • User aus der DB löschen?
    ... Bei der ursprünglichen DBs wollte ich den Username bei der ... Image und danach attach SP die DBs an Test ... aber wenn ich auf dem SQL Server den gleichen User ... Meldung dass der User bereits existiert! ...
    (microsoft.public.de.sqlserver)
  • RE: msdb
    ... Nun weis ich wie ich weiterfahren kann, ... Als Notlösung musste ich eine anderen Server nehmen, für die Produktive DBs. ... dass auch die Master DB Fehler aufweist. ...
    (microsoft.public.de.sqlserver)
Loading