RelationalDBDesign 




Managing Users   «Prev  Next»
Lesson 8 Grant SYSDBA privileges to a user
Objective Grant SYSDBA privileges to a database administrator.

Grant SYSDBA privileges to a User

Different DBA Roles
In order to allow a user to connect as a DBA and perform administrative functions, you need to grant the user one of two special roles. These roles are named SYSDBA and SYSOPER . The SYSDBA role is the most powerful because it lets you do anything. The SYSOPER role allows you to grant someone the ability to perform relatively routine tasks.Oracle also provides a DBA role, but DBA is not quite the same as SYSDBA.
  1. SYSDBA: A special type of privilege that allows the holder to administer an Oracle database. A user logged in as SYSDBA can do anything, including starting, stopping, and recovering the database.
  2. SYSOPER : A special type of privilege that allows the holder to perform several routine administrative tasks against an Oracle database. A user logged in as SYSOPER is limited to starting the database, stopping the database, certain types of recovery, and a few other routine chores.

Different DBA Roles
The following Slide Show explains what each role allows you to do:


Oracle Dba Roles
How to grant roles
To grant someone the SYSOPER or SYSDBA roles, you must be logged on as either SYSDBA or as INTERNAL. It is not enough just to have the SYSDBA role yourself; you must connect in that role. You will learn how to connect as SYSDBA later in this module. For now, continue to connect as the INTERNAL user.
Here is an example that shows how to grant the SYSDBA role to a SYSTEM user:
SVRMGR> connect internal/herman
Connected.
SVRMGR> grant sysdba to system;
Statement processed.
SVRMGR>

Granting Privileges - Exercise
When you grant the SYSDBA or SYSOPER roles to a user, that user is immediately given an entry in the password file. The entry for that user will remain as long as the user continues to hold either of those roles.
Before moving on to the next lesson, click the Exercise link below to grant the SYSDBA role to the SYSTEM user in your COIN database.
Granting Privileges - Exercise

Learn more about Oracle Tables and Database Design