oracle ȨÏÞ

--ʹÓÃDBA´´½¨Á½¸öÓû§
create user gubo identified by gubo;
create user gubo2 identified by gubo;
--¸øÁ½¸öÓû§Á¬½ÓȨÏÞ
grant create session to gubo;
grant create session to gubo2;
--¸øÆäÖÐÒ»¸öÓû§·ÃÎʱí¿Õ¼äµÄȨÏÞ
grant unlimited tablespace to gubo; 
--Á¬½ÓÆäÖÐÓû§£¬´´½¨±í
--conn gubo
create table test (a char(10));
--½¨Á¢Ò»µã²âÊÔÊý¾Ý
insert into test values ('abc');
insert into test values ('abcd');
commit;
--ĬÈϵÄÇé¿öÏ£¬ÎÒʹÓõÄoracleÓÃÓû§2¾Í¿ÉÒÔ·ÃÎÊÓû§1µÄ±íÁË£¬²»ÖªµÀÕâ±ßµÄÇé¿ö
--Èç¹ûҪʹÓø³È¨ÊÇÏÂÃæµÄÓï¾ä
grant select on TEST to gubo2£»
--ÕâÌõÓï¾äÄã³¢ÊÔÓÃÏÂ×Ô¶¯Éú³É¸³ËùÓе±Ç°Óû§±íµÄȨÏÞµÄ
select 'grant select on '|| TNAME ||' to gubo2;' from tab; 
--ÊÕ»ØȨÏ޵ķ½·¨
revoke select on TEST from gubo2;
--ʹÓÃgubo2Óû§·ÃÎÊguobÓû§µÄ±í
select * from GUBO.test;
--ÎÒÊÔ¹ýÊÇÎÞȨ¸ü¸ÄµÄ
ÁíÍâÈç¹û²»ÏëʹÓà GUBO.testÕâÑùͨ¹ýÓû§Ãûǰ׺µÄ·½Ê½·ÃÎÊÒ»°ëÊǽ¨Á¢Í¬Òå´Ê£¬ÎҾͲ»¶àдÁË