Oracle Roles

From DBArtisan
Jump to: navigation, search

Go Up to Roles

Roles are a mechanism for streamlining the assignment of object and system privileges to multiple users. Instead of granting sets of privileges to individual users, you can create a role, grant system and object privileges to that role, then simply grant that role to all the users who should share the same privileges. You can grant one or more roles to the same user.

DBMS-specific functionality

  • For information on activating and deactivating roles for the current login in the current session, see Role Activation.