What Are the System Predefined User Roles

Home > Oracle > General

Q

What Are the System Predefined User Roles? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges

✍: 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.

2007-05-02, 4904👍, 0💬

How To List All User Accounts
How To List All User Accounts? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges User accounts can be accessed through a system view called ALL_USERS. A simple SELECT statement can be used to get a list of all user accounts. Try the following script: >.\bin\sqlplus /nolog SQL> ... 2007-05-02, 5020👍, 0💬

What Are the System Predefined User Roles
What Are the System Predefined User Roles? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges 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 - Enabl... 2007-05-02, 4905👍, 0💬

What Is a User Role
What Is a User Role? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges A user role is a group of privileges. Privileges are assigned to users through user roles. You create new roles, grant privileges to the roles, and then grant roles to users. 2007-05-02, 4588👍, 0💬

How To Create a New User Account
How To Create a New User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connecte... 2007-05-02, 4568👍, 0💬

How To Use Windows User to Connect to the Server
How To Use Windows User to Connect to the Server? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges During the installation process, 10g XE will create a special Windows user group called ORA_DBA, and put your Windows user into this group. Any Windows users in this group can be... 2007-05-02, 4560👍, 0💬

How Remove Data Files befor opening a Database
How Remove Data Files befor opening a Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline befor o... 2007-05-02, 4553👍, 0💬

What Are Internal User Account
What Are Internal User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges An internal user account is a system predefined user account. Oracle 10g XE comes with a number of internal accounts: SYSTEM - This is the user account that you log in with to perform all administ... 2007-05-02, 4549👍, 0💬

What Is the Relation of a User Account and a Schema
What Is the Relation of a User Account and a Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the ... 2007-05-02, 4509👍, 0💬

How To Connect to the Server with User Account: SYS
How To Connect to the Server with User Account: SYS? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges SYS is a very special user account. It has been associated with the highest privilege call SYSDBA. Normally, you should not connect to the server with SYS. But if you want to ... 2007-05-02, 4452👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.