Another 11gr2 oddity...
From: Noons <wizofoz2k_at_gmail.com>
Date: Tue, 26 Jun 2012 17:35:12 -0700 (PDT)
Message-ID: <ee244649-f5cb-455c-9583-01f5b8019c4b_at_q5g2000pba.googlegroups.com>
11.2.0.3 upgraded from 10.2.0.3 via standard dbua:
Date: Tue, 26 Jun 2012 17:35:12 -0700 (PDT)
Message-ID: <ee244649-f5cb-455c-9583-01f5b8019c4b_at_q5g2000pba.googlegroups.com>
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...)
Received on Tue Jun 26 2012 - 19:35:12 CDT