Re: How does Oracle identify a user as DBA

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Wed, 16 Jan 2002 23:26:56 +0000
Message-ID: <3C460C40.4043D5C3@exesolutions.com>

You are incorrect in that you are misinterpreting what is happening. There is a system privilege that allows it. That privilege is independent of the role named DBA.

Daniel Morgan

Faisal Qasim wrote:

> Thanks. But Oracle identifies a user as DBA and then allow login, even
> when sessions not available, as you can see in excerpt from alert
> file.
>
> "Wed Jan 16 12:04:51 2002
> License maximum (46) exceeded, DBA logon allowed"
>
> Regards
>
> "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
Received on Wed Jan 16 2002 - 17:26:56 CST