Re: 10gR2, problem about Resource role
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Nov 2006 00:13:11 -0500
Absolutely correct. But who'd got that bright idea to make CONNECT
role setup in that way until and including 10.2.0.1? There must be
some explanation. :)
On 11/1/06, fairlie rego <fairlie_r@xxxxxxxxx> wrote:
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
--
Best regards,
Alex Gorbachev
The Pythian Group
Sr. Oracle DBA
http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
