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@xxxxxxxxx> 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

Other related posts: