Basic Oracle Concepts and Programming Question:
What Are the System Predefined User Roles?
Answer:
Oracle 10g XE comes with 3 predefined roles:
* CONNECT - Enables a user to connect to the database. Grant this role to any user or application that needs database access.
* RESOURCE - Enables a user to create certain types of schema objects in his own schema. Grant this role only to developers and to other users that must create schema objects. This role grants a subset of the create object system privileges.
* DBA - Enables a user to perform most administrative functions, including creating users and granting privileges; creating and granting roles; creating and dropping schema objects in other users' schemas; and more. It grants all system privileges, but does not include the privileges to start up or shut down the database. It is by default granted to user SYSTEM.
* CONNECT - Enables a user to connect to the database. Grant this role to any user or application that needs database access.
* RESOURCE - Enables a user to create certain types of schema objects in his own schema. Grant this role only to developers and to other users that must create schema objects. This role grants a subset of the create object system privileges.
* DBA - Enables a user to perform most administrative functions, including creating users and granting privileges; creating and granting roles; creating and dropping schema objects in other users' schemas; and more. It grants all system privileges, but does not include the privileges to start up or shut down the database. It is by default granted to user SYSTEM.
| Previous Question | Next Question |
| What Is an Oracle User Role? | What Are Internal User Account in Oracle? |