Re: How does Oracle identify a user as DBA

From: Murali <oraclems_at_hotmail.com>
Date: 17 Jan 2002 07:44:00 -0800
Message-ID: <22e6597b.0201170744.25bf513c@posting.google.com>

"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:<3C45775E.4E174224_at_exesolutions.com>...
> Oracle does not identify users as DBA.
>
> DBA is just the name of a role that contains multiple system privileges.
>
> Daniel Morgan
>
>
>
> Faisal Qasim wrote:
>
> > Dear all,
> >
> > On the basis of which system privileges, Oracle defines a user as DBA?
> >
> > A DBA is allowed to login, even after max. no. of sessions exceeded.
> >
> > Regards

Maybe you are thinking of the system privileges SYSDBA and SYSOPER, which allows a user to login to the database to do maintainence tasks (like shutdown, recover etc.). These users and their passwords are stored in a binary file called the password file (or they are authenticated by the operating system), so that when the db is down, or max sessions have been exceeded, these users can be authenticated by Oracle to perform DBA tasks. There is also a database role called DBA, but that is valid only when the database is open.

Murali
http://www.dbaquest.com/ Received on Thu Jan 17 2002 - 09:44:00 CST