-- Oracle create user.sql
------------------------创建用户----------------------
create user 20131026 identified by 20131026
default tablespace ring
temporary tablespace temp
/
------------------------授权用户----------------------
grant connect, resource, create any table, drop any table, create sequence,
alter any trigger, create any trigger, drop any trigger,
alter any type, create any type, drop any type,
create any view, drop any view,
create procedure, imp_full_database, exp_full_database,
create any directory, debug connect session,
create session to 20131026
/
grant execute on dbms_lock to 20131026
/
grant execute on dbms_job to 20131026
/
grant create job to 20131026
/
grant select on v_$session to 20131026
/
Oracle create user
最新推荐文章于 2021-09-24 08:59:47 发布