oracle grant

oracle grant
ÊÚȨÓï¾ä--select * from dba_users; ²éѯÊý¾Ý¿âÖеÄËùÓÐÓû§
--alter user TEST_SELECT account lock; ËøסÓû§
--alter user TEST_SELECT account unlock; ¸øÓû§½âËø
--create user xujin identified by   xujin; ½¨Á¢Óû§
--grant create tablespace to xujin; ÊÚȨ
--grant select on tabel1 to xujin; ÊÚȨ²éѯ
--grant update on table1 to xujin;
--grant execute on procedure1 to xujin ÊÚȨ´æ´¢¹ý³Ì
--grant update on table1 to xujin with grant option; ÊÚȨ¸üÐÂȨÏÞתÒƸøxujinÓû§£¬Ðí½øÓû§¿ÉÒÔ¼ÌÐøÊÚȨ£»
--ÊÕ»ØȨÏÞ
--revoke select on table1 from xujin1; Êջزéѯselect±íµÄȨÏÞ£»
--revoke all on table1 from xujin;
/*grant connect to xujin;
revoke connect from xujin
grant select on xezf.cfg_alarm to xujin;
revoke select on xezf.cfg_alarm from xujin;*/
--select table_name,privilege from dba_tab_privs where grantee='xujin' ²éѯһ¸öÓû§ÓµÓеĶÔÏóȨÏÞ
--select * from dba_sys_privs where grantee='xujin' ²éѯһ¸öÓû§ÓµÓеÄϵͳȨÏÞ
--select * from session_privs --µ±Ç®»á»°ÓÐЧµÄϵͳȨÏÞ
--½ÇÉ«
--create role xujin1;--½¨Á¢xujin1½ÇÉ«
--grant insert on xezf.cfg_alarm to xujin1; ½«²åÈë±íµÄÐÅÏ¢
--revoke insert on xezf.cfg_alarm from xujin1; ÊÕ»Øxujin1½ÇÉ«µÄȨÏÞ
--grant xujin1 to xujin ; ½«½ÇÉ«µÄȨÏÞÊÚȨ¸øxujin;
-- create role xujin2;
--grant xujin1 to xujin2; ½«½ÇÉ«xujin1ÊÚȨ¸øxujin2;
--alter user xujin default xujin1,xujin2; ÐÞ¸ÄÓû§Ä¬ÈϽÇÉ«
-- DROP ROLE xujin1;ɾ³ý½ÇÉ«1£»
--select * from role_sys_privs where role=xujin1;
--²é¿´Ðí½ø1½ÇÉ«ÏÂÓÐʲôϵͳȨÏÞ£»
--select granted_role,admin_option from role_role_privs where role='xujin2';
--²é¿´xujin1½ÇÉ«ÏÂÃæÓÐʲô½ÇɫȨÏÞ
--select * from role_sys_privs where role='xujin2';
--select table_name,privilege from role_tab_privs where role='xujin1';
--select * from dba_role_privs where grantee='xujin' --²é¿´Óû§ÏÂÃæÓжàÉÙ¸ö½ÇÉ«£»