Setting and Retrieving User and Group Permissions

Users and groups of users can be granted specific permissions to database objects. For example, a user or an entire group of users can be authorized to only read an object's contents while other users or groups can have less restrictive access to a database, allowing them to modify or delete objects.

It is important to understand that when you set permissions for a group, every user in that group automatically inherits those permissions. Also, keep in mind that while the user and group accounts are stored in the workgroup information file, the permissions that those users/groups have to specific objects are stored in system tables in your database.

The following sections of this chapter will familiarize you with using ADOX to retrieve, list, and set permissions for various database objects.

0 0

Post a comment