OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » role and privileges

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

role and privileges [message #60401]

Thu, 05 February 2004 18:25

Sam
Messages: 255
Registered: April 2000

Senior Member

hi, can anybody pls tell me which view contains the details of a role and the privileges it has got. i want to grant a user some roles but not sure which role contains what privileges.

thanx in advance

Report message to a moderator

Re: role and privileges [message #60410 is a reply to message #60401]

Fri, 06 February 2004 01:34

Sunil
Messages: 132
Registered: September 1999

Senior Member

You may use ROLE_SYS_PRIVS to view what privileges are conatined in a role.

or you may view all such views using

SELECT * FROM DICT WHERE TABLE_NAME LIKE '%PRIVS%';

Report message to a moderator

Re: role and privileges [message #60411 is a reply to message #60401]

Fri, 06 February 2004 02:05

Thiru
Messages: 1089
Registered: May 2002

Senior Member

role_tab_privs
role_sys_privs
role_role_privs
dba_role_privs
dba_sys_privs
dba_tab_privs

eg)

thiru@9.2.0:SQL>select granted_role from role_role_privs where role='DBA';

GRANTED_ROLE
------------------------------
XDBADMIN
PLUSTRACE
JAVA_ADMIN
JAVA_DEPLOY
WM_ADMIN_ROLE
EXP_FULL_DATABASE
IMP_FULL_DATABASE
DELETE_CATALOG_ROLE
SELECT_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
GATHER_SYSTEM_STATISTICS

11 rows selected.

thiru@9.2.0:SQL>select privilege from dba_sys_privs where grantee='CONNECT';

PRIVILEGE
----------------------------------------
CREATE VIEW
CREATE TABLE
ALTER SESSION
CREATE CLUSTER
CREATE SESSION
CREATE SYNONYM
CREATE SEQUENCE
CREATE DATABASE LINK

8 rows selected.

-Thiru

Report message to a moderator

Previous Topic:	SHM_SHARE_MMU segment warning
Next Topic:	clone DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 08 20:52:15 CDT 2025