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: rjamya <rjamya_at_gmail.com>
Date: Wed, 1 Nov 2006 06:44:46 -0500
Message-ID: <9177895d0611010344l69575084m9af328398958f192@mail.gmail.com>


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
Received on Wed Nov 01 2006 - 05:44:46 CST

Original text of this message

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