oracle创建新用户及授予常用权限

最新推荐文章于 2023-11-16 21:18:19 发布

原创最新推荐文章于 2023-11-16 21:18:19 发布 · 208 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

Oracle 专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了如何在数据库环境中创建用户并授予相应的权限，包括一般权限和DBA权限，确保用户能够在数据库系统中执行所需操作。

创建用户

create user username
identified by username
default tablespace tablespace_name;

授予一般权限

grant connect,resource,create any table,drop any table,create sequence,
      select any table, create any index, drop any index,
      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 any directory,
      create procedure, query rewrite, create session to username;

授予DBA权限

grant select on sys.v_$process to username;
grant select on sys.v_$parameter to username;
grant execute on dbms_lock to username;
grant select on sys.v_$lock to username;
grant select on sys.v_$session to username;
grant select on sys.v_$mystat to username;
grant select on sys.v_$session_wait to username;
grant select on dba_kgllock to username;
grant select on sys.v_$sqltext to username;
grant select on sys.slog$ to username;
grant alter session to username;
grant select on dba_undo_extents to username;
grant select on dba_tablespaces to username;
grant select on dba_free_space to username;
grant select on dba_data_files to username;