Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How does Oracle identify a user as DBA

Re: How does Oracle identify a user as DBA

From: s.kapitza <skapitza_at_volcanomail.com>
Date: 16 Jan 2002 23:42:34 -0800
Message-ID: <26703915.0201162342.138b424c@posting.google.com> 





hi faisal,



try 


SQLPLUS>select userenv('isdba') from dual;



hth



s.Kapitza





faisal_qasim_at_my-deja.com (Faisal Qasim) wrote in message news:<7d83d0a4.0201152352.5e514782_at_posting.google.com>...


> 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 Thu Jan 17 2002 - 01:42:34 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US