Subject | Setting up security |
---|---|
Author | Dion |
Post date | 2001-08-22T14:55:41Z |
Hi,
If anyone has some time in hand please help me out, if not please point me
to the right user group.
I need advice with the following problem. I want to administer user rights
in a user table within a database. I basically want to store the users
rights in a field(per user). His rights will be loaded when his logon is
successful. It is here where the problem is. I will have to embed a user
name in the exe(bad idea) without a password(another one) sothat a
connection can be established in the background and validation done against
the user table. The application will reflect the rights for this user when
they are loaded(ie menu items greyed etc). Is there a better way of
implementing user rights or permissions in this fashion. The users will not
be able to access the db via other utilities like dbexplorer as they will
not have valid db usernames, as I have implemented my own user table.
Regards,
Dion.
If anyone has some time in hand please help me out, if not please point me
to the right user group.
I need advice with the following problem. I want to administer user rights
in a user table within a database. I basically want to store the users
rights in a field(per user). His rights will be loaded when his logon is
successful. It is here where the problem is. I will have to embed a user
name in the exe(bad idea) without a password(another one) sothat a
connection can be established in the background and validation done against
the user table. The application will reflect the rights for this user when
they are loaded(ie menu items greyed etc). Is there a better way of
implementing user rights or permissions in this fashion. The users will not
be able to access the db via other utilities like dbexplorer as they will
not have valid db usernames, as I have implemented my own user table.
Regards,
Dion.