Oracle create user

jis117

于 2013-10-26 08:52:25 发布

阅读量228

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/jis117/article/details/84492778

本文详细介绍了如何使用Oraclecreateuser.sql脚本创建特定用户并授予其关键操作权限，包括连接、资源、表创建与删除等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


-- 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
/