Privs of RESOURCE role not showing up

From: Jerome Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Thu, 30 Nov 2006 16:17:34 +0100
Message-ID: <456ef524$0$24424$426a74cc@news.free.fr>

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 Received on Thu Nov 30 2006 - 09:17:34 CST