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_at_yahoo.com> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 31 2006 - 23:13:11 CST
