Re: 10gR2, problem about Resource role

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: jerrysun1981@xxxxxxxxxxx
  • Date: Tue, 31 Oct 2006 13:20:52 +0000

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

Other related posts: