RelationalDBDesignRelationalDBDesign


Security Roles   «Prev 

System defined roles

Your Oracle database has a number of predefined roles and these roles are simple groupings, although they are groupings of system privileges rather than object privileges.
There are nine system roles available with Oracle8. The two most commonly used roles are:
CONNECT: Gives a user the ability to create a session and create basic database objects
DBA: Gives the user all system privileges, each with WITH ADMIN OPTION, which is explained in a later lesson

The CONNECT role is usually granted to all new database users, while the DBA role must be granted very selectively because of its power.