02.Oracle/DataBase2008. 7. 18. 11:53
반응형

CREATE USER test1521 IDENTIFIED BY test1521;
GRANT CREATE SESSION TO test1521;
GRANT SELECT ON SMBI.sbcsba2007 TO test1521;

scott : DB
student : Table Name
tiger : 계정



GRANT SELECT ON SMBI.cuolac TO test1521;
GRANT SELECT ON SMBI.sbcsba2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbb2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbc2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbe2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbg2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbh2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbi2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbk2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbo2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbp2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbr2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbr22007 TO test1521;
GRANT SELECT ON SMBI.sbcsbs2007 TO test1521;
GRANT SELECT ON SMBI.sbcsbt2007 TO test1521;

Posted by 1010