Home » RDBMS Server » Server Administration » SYSTEM, sysdba, sysoper
SYSTEM, sysdba, sysoper [message #526560] Tue, 11 October 2011 10:05 Go to next message
hanner
Messages: 90
Registered: August 2011
Location: at HOME
Member
my understanding of the above from this forum and self- reading:

is that among the 3, they are not 'of - less privilege' between each other.

Is something like a function group, each performing certain task.

Can help to list out (in practical way) when, you log in as one of them and what are you practically doing.

What i came to know is that sys admin who maintain a unix system have the privilege to actually perform start up and shutdown a db. So i guess they are given a system role?

Of course they are not able to create or drop any db that role is obviously reserved to dba.

This all that i know practically.
Re: SYSTEM, sysdba, sysoper [message #526564 is a reply to message #526560] Tue, 11 October 2011 10:11 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Database Administrator's Guide
Chapter 1 Overview of Administering an Oracle Database
Sections Database Administrator Usernames and Administrative Privileges.

Regards
Michel

Previous Topic: LGWR - sequence
Next Topic: possible to find out last access to a table?
Goto Forum:
  


Current Time: Fri Nov 29 04:38:35 CST 2024