Users can access only database objects on which they have privileges. The following table lists the types of database privileges and describes how a user acquires them.
Privilege | How Acquired |
---|---|
Implicit (Ownership) | Granted by database to owner of space where database objects are created. |
Automatic | Granted automatically by the system to the following:
|
Inherited | Granted indirectly to user based on relationship to another user or role to which the privileges were granted directly. Directory users inherit privileges of database users to which they are mapped. Directory users who are members of groups also inherit privileges defined in external roles to which the groups are mapped. All users inherit privileges of default database user PUBLIC. |
Explicit (GRANT) | Granted explicitly to user or database in one of the following ways:
|