What are the system predefined user roles?

<<Previous  Next>>

Oracle - What are the system predefined user roles? - June 27, 2009 at 11:00 AM

What are the system predefined user roles?  

Oracle 10g XE comes with 3 predefined roles:

CONNECT
This role enables a user to connect to the database.
Any user or application that needs database access should be granted this role.

RESOURCE
This role enables a user to create certain types of schema objects in that particular user’s schema.
Users who need to create schema objects should be granted this role. E.g.: Developers
This role grants a subset of the create object system privileges.

DBA
This role enables a user to perform most administrative functions like:
• Creating users
• Granting privileges to users
• Creating and granting roles
• Creating and dropping schema objects of other users

It grants all system privileges with an ADMIN option.

Also read

Oracle Security

Explain the security features in Oracle, What are roles? How can we implement roles?, What is user Account in Oracle database?, What is a trace file and how is it created?, What are Tablespace Quota and default tablespace?............

Use of Roles in oracle

Roles in Oracle can be used to grant privileges to a specific group of users for security. The database manager is usually responsible for granting privileges to a Role..........

What are internal user accounts in Oracle?

There are a few predefined accounts set by the System in Oracle...........

Describe how to revoke CREATE SESSION privilege from a user.

If a CREATE SESSION privilege has been taken from a user, then REVOKE can be used as follows:...........

<<Previous  Next>>

Write your comment - Share Knowledge and Experience