Re: Privs of RESOURCE role not showing up

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 30 Nov 2006 08:54:44 -0800
Message-ID: <1164905683.584685@bubbleator.drizzle.com>

Jerome Vitalis wrote:
> This is 9.2.0.7.0 on Windows :
>
> select privilege from dba_sys_privs where grantee='RESOURCE'
>
> PRIVILEGE
> ----------------------------------------
> CREATE TYPE
> CREATE TABLE
> CREATE CLUSTER
> CREATE TRIGGER
> CREATE OPERATOR
> CREATE SEQUENCE
> CREATE INDEXTYPE
> CREATE PROCEDURE
>
> 8 rows selected
>
>
> select privilege from role_sys_privs where role='RESOURCE'
>
> PRIVILEGE
> ----------------------------------------
>
> 0 rows selected
>
>
> Why don't these privileges show up in the role_ view?
>
> TIA
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 30 08:53:41 2006

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> select privilege from role_sys_privs where role='RESOURCE';

PRIVILEGE

---

CREATE SEQUENCE
CREATE TRIGGER
CREATE CLUSTER
CREATE PROCEDURE
CREATE TYPE
CREATE OPERATOR
CREATE TABLE
CREATE INDEXTYPE 8 rows selected.

SQL> Wrong version of Oracle? <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Nov 30 2006 - 10:54:44 CST