Oracle 创建用户

最新推荐文章于 2024-07-29 22:07:59 发布

小狮王

最新推荐文章于 2024-07-29 22:07:59 发布

阅读量219

点赞数

分类专栏： Oracle 文章标签： oracle

本文链接：https://blog.csdn.net/wanghaoqian/article/details/78597687

版权

Oracle 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

创建用户

-- Create the user 
create user MEP
  identified by whq1987
  default tablespace MEP
  temporary tablespace MEP_TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges 
grant connect to MEP;
grant datapump_exp_full_database to MEP;
grant datapump_imp_full_database to MEP;
grant dba to MEP;
grant exp_full_database to MEP;
grant imp_full_database to MEP;
grant resource to MEP;
-- Grant/Revoke system privileges 
grant alter_user to MEP;
grant comment any table to MEP;
grant create any view to MEP;
grant create session to MEP;
grant create user to MEP;
grant delete any table to MEP;
grant drop user to MEP;
grant export full database to MEP;
grant unlimited tablespace to MEP;