| OSDBA , OSOPER privileges [message #64471] |
Mon, 31 January 2005 21:06  |
Sanjeev Suri
Messages: 11
Registered: September 2004
|
Junior Member |
|
|
Sirs, I want in detail regarding OSDBA & OSOPER privileges i.e. how one can assign it.
Pl. let me know
Thanks
Sanjeev Suri
|
|
|
|
| Re: OSDBA , OSOPER privileges [message #64473 is a reply to message #64471] |
Mon, 31 January 2005 22:20  |
sri
Messages: 154
Registered: February 2000
|
Senior Member |
|
|
these groups basically as the "dba" group.
If your user who logs in as dba group has both(osoper and osdba privileges).
Two special operating system roles control database administrator logins when using operating system authentication: OSOPER and OSDBA.
OSOPER
Permits the user to perform STARTUP, SHUTDOWN, ALTER DATABASE OPEN/MOUNT, ALTER DATABASE BACKUP, ARCHIVE LOG, and RECOVER, and includes the
RESTRICTED SESSION privilege.
OSDBA
Contains all system privileges with ADMIN OPTION, and the OSOPER role; permits CREATE DATABASE and time-based recovery.
For using this role,you have a os group osoper or osdba.
Your user should be assigned this groups.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
