ORACLE新建用户.txt 307 B

12345678910111213141516
  1. -- ´´½¨Óû§
  2. create user bhrs2mis
  3. identified by bhrs2mis
  4. default tablespace USERS
  5. temporary tablespace TEMP
  6. profile DEFAULT;
  7. -- ·ÖÅäȨÏÞ
  8. grant connect to bhrs2mis;
  9. grant resource to bhrs2mis;
  10. grant dba to bhrs2mis;
  11. grant select on tousu_uat.x_appeal to bhrs2mis
  12. SELECT * FROM TOUSU_UAT.X_APPEAL