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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10gR2, problem about Resource role

Re: 10gR2, problem about Resource role

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Tue, 31 Oct 2006 21:00:04 -0800 (PST)
Message-ID: <20061101050004.80278.qmail@web31904.mail.mud.yahoo.com>


Also, have you ever wonder why CONNECT role contains more that just CREATE SESSION privilege?

  Alex    

  I believe this has been finally rectified in 10.2    

  SQL> select privilege from dba_sys_privs where grantee='CONNECT';   PRIVILEGE



CREATE SESSION       Regards,
  Fairlie

          Fairlie Rego
Senior Oracle Consultant
  http://www.linkedin.com/in/fairlierego   

  http://el-caro.blogspot.com/
  M: +61 402 792 405      



Access over 1 million songs - Yahoo! Music Unlimited Try it today.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 31 2006 - 23:00:04 CST

Original text of this message

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