Data Owner & User Access Level Security

BUDS

New member
Local time
Today, 16:57
Joined
Dec 15, 2010
Messages
5
He guys,

I am planning to create another type of level security as this database will be going to share around 20 persons for all superintendent in one of a leading petrochemical in KSA. I want to declare that if Abdullah will log on he can create a request and can add attachment on it. And if Mohammed will log on he can view as read only the request of Abdullah nor he can't modify, vice and versa. But however if the administrator he can modify any of those request of Mr. Abdullah & Mohammed.

Is this possible to declare such kind of user level category? Probably this might require a module just to look up of each log on value depending to its user access level.

Any help would much be appreciated.

Thanks,
 
Sounds like you just need to create a UserGroups table and then a Users table. Make sure each user gets assigned to a UserGroup. Then you'll have to determine which access level takes precedence but it's usually recommended to stick completely with group level security instead of assigning certain permissions to each user.

I'm assuming you aren't using the MS Access built-in security, or are you?
 
Hi Dear,

You are right I need to declare a user group but in access 2007 the user group utility has been removed. So in this case I don't how to start on it. If ever you had some example that would be great as I am fairly new in access.

Thanks,
 
This gets really complex quite quickly.

Do you want the user to log in at that start of the app or for every screen they go into?
Do you want users to be able to be in more than one group like Windows Server allows? I don't recommend this.
What all would you expect to apply these permissions to, just forms?

It's best to store only the one-way hash for a user's password. I worked a little while on setting up an example database but it isn't ready for primetime yet.
 

Users who are viewing this thread

Back
Top Bottom