About Users, Roles, and Privileges
The Users and Roles Management feature in Oracle Developer Tools allows you to manage users, roles, and privileges in the database. You can view users and roles through the Server Explorer. There are designers to create and modify them.
About Users and Roles
Before users can connect to an Oracle database, you need to create user accounts and roles for them.
A role is a set of privileges that you can grant to users or to other roles. The default Oracle Database installation include several sample users and roles, such as the HR user and the DBA role.
You can create user accounts and roles from the Users and Roles Management feature in Oracle Developer Tools as well as in several Oracle Database tools, such as SQL*Plus or the Oracle Enterprise Manager Database Control, which is installed with Oracle Database.
For detailed information on how user accounts and roles work, or how to create and manage user accounts from SQL*Plus, see Oracle Database Administrator's Guide. For more information on Enterprise Manager Database Control, see Oracle Database 2 Day DBA.
About Privileges
A privilege is the right to run a particular type of SQL statement or to access another user's object. Examples of privileges on a table are ALTER, INSERT, and DELETE.
Viewing Users and Roles in Server Explorer
Server Explorer displays users and roles in two different views, in the object view and in the schema view. You can switch between these two views by selecting the connection node and choosing Change View, then Objects or Schemas from the menu. In the object view, all schema objects of the same type are grouped under the same collection node (such as Tables), and the name of the schema object is prefixed with the schema name in parenthesis. In the schema view, the schema objects are grouped under a Schema node.
The labels Users and Schemas are used interchangeably depending on the view. When you are in schema view, the Schemas label is used and when you are in object view, the Users label is used.
There is also a Roles node in Server Explorer. When you are logged in as SYSDBA, in Server Explorer, in schema view, you view all roles in the database. If you are a non-SYSDBA user, or a SYSDBA user viewing Server Explorer in object view, you view the roles that are assigned to you.
See Also