Re: How does Oracle identify a user as DBA

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: Thu, 17 Jan 2002 03:01:34 GMT
Message-ID: <3C463F17.15BBEBAB@rationalconcepts.com>

Well,

this information can be found in the documentation... But, here we go.
select privilege from role_sys_privs where role = 'DBA';

You should see the RESTRICTED SESSION privilege returned in the list.

Go to technet.oracle.com and and use the search capability and look up RESTRICTED SESSION. hth,
Cindy

Keith Boulton wrote:

> 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
> >
>
> Which doesn't answer the question. There is presumably a particular
> privilege which allows logon when only dba login is allowed.
Received on Wed Jan 16 2002 - 21:01:34 CST