Re: Another 11gr2 oddity...

From: Matthias Hoys <matthias.hoys_at_gmail.com>
Date: Wed, 27 Jun 2012 04:07:24 -0700 (PDT)
Message-ID: <20ab974e-6ac8-44ae-9d95-ced0b8444dac_at_googlegroups.com>

On Wednesday, June 27, 2012 2:35:12 AM UTC+2, Noons wrote:
> 11.2.0.3 upgraded from 10.2.0.3 via standard dbua:
>
> SQL> select * from dba_sys_privs
> where grantee = 'RESOURCE'; 2
>
> GRANTEE
> PRIVILEGE ADM
> ------------------------------
> ---------------------------------------- ---
> RESOURCE CREATE
> TRIGGER NO
> RESOURCE CREATE
> SEQUENCE NO
> RESOURCE CREATE
> CLUSTER NO
> RESOURCE CREATE
> TYPE NO
> RESOURCE CREATE
> PROCEDURE NO
> RESOURCE CREATE
> TABLE NO
> RESOURCE CREATE
> INDEXTYPE NO
> RESOURCE CREATE
> OPERATOR NO
>
> Original 10.2.0.3:
>
> SQL> select * from dba_sys_privs
> where grantee = 'RESOURCE'; 2
>
> GRANTEE
> PRIVILEGE ADM
> ------------------------------
> ---------------------------------------- ---
> RESOURCE CREATE
> VIEW NO
> RESOURCE CREATE
> TRIGGER NO
> RESOURCE CREATE
> SEQUENCE NO
> RESOURCE CREATE
> CLUSTER NO
> RESOURCE CREATE
> TYPE NO
> RESOURCE CREATE
> PROCEDURE NO
> RESOURCE CREATE
> TABLE NO
> RESOURCE CREATE
> INDEXTYPE NO
> RESOURCE CREATE
> OPERATOR NO
>
>
> Notice anything missing in the 11.2.0.3 resource role after the
> upgrade?
> Ah yes, it's a "feature". Like, the size of a bus?
> (...patience, Nuno, patience...)

It's strange that they took only the CREATE VIEW privilege away... is this some kind of security measure?

Matthias Received on Wed Jun 27 2012 - 06:07:24 CDT