orcal新建用户

Create the user 
create user HR
  identified by ""
  default tablespace USERS
  temporary tablespace TEMP
  profile DEFAULT
  password expire
  quota unlimited on users;
-- Grant/Revoke object privileges 
grant execute on DBMS_STATS to HR;
-- Grant/Revoke role privileges 
grant connect to HR;
grant resource to HR;
-- Grant/Revoke system privileges 
grant alter session to HR;
grant create database link to HR;
grant create sequence to HR;
grant create session to HR;
grant create synonym to HR;
grant create view to HR;
grant unlimited tablespace to HR;

  

posted @ 2018-09-18 09:53  是九离呀  阅读(59)  评论(0)    收藏  举报