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: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 31 Oct 2006 13:20:52 +0000
Message-ID: <be592d550610310520s762cd39bjbb5bddbf2b440edd@mail.gmail.com>


not a bug and definietly not a phenomena. It has been this way for years. When you grant the resource role, you explicitly get granted the unlimited tablespace privelege.

Documented, known and understood, if you dont like it - dont assign anyone resource

On 31/10/06, ?? ? <jerrysun1981_at_hotmail.com> wrote:
>
>
> problem comes out, why and when the "UNLIMITED TABLESPACE" privilege was
> granted to user "TEST", i am sure that the "UNLIMITED TABLESPACE" here
> derive from "RESOURCE" role, anybody has any idea about this phenomena? is
> this a oracle bug ?
>
> thanks in advance, and sorry for my poor english
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 31 2006 - 07:20:52 CST

Original text of this message

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