in reply to User access DB design

Hmm.. why not use the built in user access of MySQL? It has several advantages - fast, reliable, builtin already, already documented.. etc.
Also allows for access restriction per site location, table, column.. etc.
All you would need to do for administration is make a standard user rights manager (one already comes with MySQL). Additionally it is network friendly for backups - (it resides in the database after all)

Replies are listed 'Best First'.
Re: Re: User access DB design
by suaveant (Parson) on Nov 01, 2001 at 19:23 UTC
    Umm... no, this isn't for access to the DB, this is for various access priviledges on our web site (financial data)

                    - Ant
                    - Some of my best work - (1 2 3)