Re: sysdba and sysoper

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 18 Sep 1999 22:42:23 +0200
Message-ID: <937687412.18098.0.pluto.d4ee154e@news.demon.nl>

1 sysdba and sysoper is not the same as dba. Anyone with sysdba can shut the database, place it in restricted mode and so on. An user with dba privilege can't
2 Users with sysdba privilege are no ordinary users anymore, they function as internal: they are in the passwordfile and you still can use them if the database is unavailable.

Hthm

--
Sybrand Bakker, Oracle DBA
Doug Cowles <dcowles_at_nospambigfoot.com> wrote in message news:37E3E70B.BB52E678_at_nospambigfoot.com...
> Basic question about sysdba and sysoper. What's the rationale for using
> them if you can log in as a user with dba privileges? Is this for
> systems where for security reasons, system, sys etc., have been
> disabled?
>
Received on Sat Sep 18 1999 - 15:42:23 CDT