Tuesday, 20 November 2012

To find all Sys Priviliges under a role in Oracle 10g

Select privilege from DBA_SYS_PRIVS where grantee like 'RESOURCE' order by privilege;

RESOURCE
------------------------
create cluster
create indextype
create operator
create procedure
create sequence
create table
create trigger
create type

No comments:

Post a Comment