Re: Multiple User Accounts



In article <1i5h55l.158m0ezc8v1dyN%clk@xxxxxxxxxxx>, clk@xxxxxxxxxxx
(Christoph Kaufmann) wrote:

mgfilemaker <mgoyeah@xxxxxxxxxxx> wrote:

any advice on the best way to set up and manage a small list of user
accounts (5-10 only). The built-in acounts and privileges functions
seem pretty awful to use. It seems that info has to be repeated for
every separate filein use, etc. I want the client to be able to
maintain a list of usernames and for each one select what access
levels they have without needing to ever go into the "acounts and
privileges" area.

If you use Active Directory in your system, check the feature "external
server" out.

If you have to manage the user account within Filemaker, create a table
for the accounts with these Fields

UserName
Level
Password
UserName_g (global)
Password_g (global)

In the file with this table you write scripts that
- sets the global fields with the value of the current record
- uses the level as script parameter
- calls the relevant script in each of your files (see below).

Make sure every file has an instance of this table on the relation
graphs. No relations are necessary.

_Every_ file needs scripts that create user accounts, delete user
accounts and reset passwords for existings user accounts. In these
scripts, you can use calculations for the usernames and password. You
put in the global fields of your user table there.

Unfortunately, you can't set the level with a calculation. First, you
have to set up the levels in each of your files. Then you can use the If
screpts together with script parameter to put a user account on the
correct level.

And after all that you've probably done more work than you would have
doe using FileMaker's in-built system ... unless you've got literally
hundreds of files. :o)

Yes, FileMaker's in-built password system is kludgey (at best) and not
as easy to use as it could be, and that's in FileMaker 5, so it's
probably worse in the new versions. BUT, it's better and probably more
secure than reinventing your own system using standard database
scripts, fields and functions.






Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.



Relevant Pages

  • Re: Multiple User Accounts
    ... If you have to manage the user account within Filemaker, ... for the accounts with these Fields ... _Every_ file needs scripts that create user accounts, ... put in the global fields of your user table there. ...
    (comp.databases.filemaker)
  • Re: changing pswds of standard accounts
    ... And if you have fix the scripts. ... Puget Sound Oracle Users Groupwww.psoug.org ... Have already locked accounts that the "home office" says are not ...
    (comp.databases.oracle.server)
  • Re: Group rename problem
    ... Yes, scripts are replicated okay. ... my test account. ... A few days ago I had to rename a few security groups in our AD. ... After the rename I made tests with my test accounts and all seemed to ...
    (microsoft.public.windows.server.general)
  • Solaris reclaiming space
    ... Solaris10 or Solaris 9? ... Three configuration scripts are left behind. ... Remove any unnecessary accounts from the system. ... The login shell should also be changed on these accounts. ...
    (comp.unix.solaris)
  • Re: All AD User Accounts Locked
    ... Thanks Rob. ... If anyone wants any sample scripts, ... > logs on domain controllers (security logs will indicate the workstation name ... The accounts could only be ...
    (microsoft.public.win2000.active_directory)

Loading