Re: 10gR2, problem about Resource role

Alex,

that isn't true in 10gr2 ... are you sure you ran this on 10gr2?

Raj

On 10/31/06, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
> Alternatively, just revoke UNLIMITED TABLESPACE after that.
> Also, have you ever wonder why CONNECT role contains more that just
> CREATE SESSION privilege?
>
> SQL> select privilege from dba_sys_privs where grantee='CONNECT';
>
> PRIVILEGE
> ----------------------------------------
> CREATE VIEW
> CREATE TABLE
> ALTER SESSION
> CREATE CLUSTER
> CREATE SESSION
> CREATE SYNONYM
> CREATE SEQUENCE
> CREATE DATABASE LINK
>

--
http://www.freelists.org/webpage/oracle-l