System Defined User Roles in Oracle


What Are the System Predefined User Roles in Oracle?



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.


Built-in Internal User Accounts in Oracle

User Role: Group of Privileges in Oracle

Managing Oracle User Accounts, Schema and Privileges

⇑⇑ Oracle Database Tutorials

2019-07-30, 1467🔥, 0💬