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.
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
Different DBA Roles
The following Slide Show explains what each role allows you to do:
When you grant the
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
role to the
Granting Privileges - Exercise