日期:2014-05-16 浏览次数:20843 次
create role myrole
identified by myrole;
grant create session,create table,create view to myrole
with admin option;
grant select,update,insert,delete
on scott.emp to myrole
create user testu identified by testu;
grant myrole to testu
SELECT * FROM ROLE_TAB_PRIVS where role='MYROLE'
SELECT * FROM ROLE_ROLE_PRIVS where role='MYROLE'
SELECT * FROM ROLE_SYS_PRIVS where role='MYROLE'
SELECT * FROM ROLE_WM_PRIVS where role='MYROLE'