Re: sysdba privileges and shutdown

Hi!

Consider them as special privileges which are granted either through passwordfile or OS user characteristics, depending on remote_login_passwordfile's value.

SYSOPER allows you to do tasks such are startup, shutdown, recover, etc.. SYSDBA allows all that SYSOPER can do, plus create database, recover until, also you get the sysdba and sysoper privileges with admin option, so you can grant those to others.

You can get the full list of privs provided by SYSDBA/OPER from docs.

You cant see them in system_privilege_map. You can query v$pwfile_users to see, to whom those privileges have been excplicitly granted (again, providing, that remote_login_passwordfile = exclusive).

Tanel.

"Rachel Wilson" <wilsonr_at_logica.com> wrote in message news:936259dc.0303100354.23a3bfe_at_posting.google.com...
> Er, guys. Thanks very much for the info, but unless I skimmed over
> it, noone has looked at my original question which was exactly what is
> sysdba and what priviledges does it have and where can those privs be
> found (if at all) in the dictionary. The security question was an
> aside really - maybe i should have made that clear. (interesting
> discussion mind you - don't get me wrong, there's no such thing as
> pointless information in my book)
Received on Mon Mar 10 2003 - 06:38:29 CST