System Defined User Roles in Oracle
Q
What Are the System Predefined User Roles in Oracle?
✍: FYIcenter.com
A
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.
2016-10-17, 281👍, 0💬