Change database user privileges

database user privileges

Several users can have different database user privileges. These privileges depends on what users are supposed to do.

There are two types of user in Access Document Management database:

  • Admin- have access to all features of database, including adding documents.
  • User- have limited access and can only search and view added documents.

To change database user privileges, add new user and assign him/her appropriate privileges please follow these instructions (as showed in video above):

1. Open database in full view (hold down SHIFT key when opening)
2. Open table "tblUser"
3. Enter user name in field "UserName" and PC user name in "UserLogin" filed
4. Change UserSecurity to Admin or User depending on user level
5. Save table and re-open database