oracleȨÏÞÎÊÌ⼯ºÏ

1.oracleÉèÖò»Í¬È¨ÏÞµÄÓû§È¥·ÃÎÊͬһ±í¿Õ¼ä
1.create user testa identified by testa;
2.alter user testa default tablespace users temporary tablespace temp;
3.grant connect to testa;
4.grant select any table to testa;
2.ORACLEÖÐÉèÖÃͬһ¸öÓû§¶ÔÁ½¸ö±í¿Õ¼äµÄȨÏ޵ĴúÂë
alter user Óû§ quota unlimited on ±í¿Õ¼äA;
alter user Óû§ quota unlimited on ±í¿Õ¼äB;
»òÕß·Å¿ªËùÓбí¿Õ¼ä
grant unlimited tablespace to Óû§;
»òÕßË÷ÐÔ¸øËùÓÐȨÏÞ
grant resource,connect,dba to Óû§;
3.ORACLEÉèÖÃÖ»ÄÜ·ÃÎʱíȨÏÞµÄÓû§
grant select on table1 to user1;
grant select on table2 to user1;