Contents Index Managing User IDs and Permissions DBA authority overview

ASA Database Administration Guide
  Managing User IDs and Permissions

Database permissions overview


Proper management of user IDs and permissions lets users of a database carry out their jobs effectively, while maintaining the security and privacy of information within the database.

You use SQL statements for assigning user IDs to new users of a database, granting and revoking permissions for database users, and finding out the current permissions of users.

Database permissions are assigned to user IDs. Throughout this chapter, the term user is used as a synonym for user ID. Remember, however, that you grant and revoke permissions for each user ID.

Setting up individual user IDs 

Even if there are no security concerns regarding a multi-user database, there are good reasons for setting up an individual user ID for each user. The administrative overhead is very low if a group with the appropriate permissions is set up. This chapter discusses groups of users.

You may want to use individual user IDs, since:


DBA authority overview
RESOURCE authority overview
Ownership permissions overview
Table and views permissions overview
Group permissions overview

Contents Index Managing User IDs and Permissions DBA authority overview