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

创建用户

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;

评论

2 楼 michael8335 2012-06-13  

mikixiyou 写道

你这里给用户授予的权限太多，一般只要connect,resource，足够。

嗯，这里有限权限是不需要的，例如一些DBA的视图等，希望以后关于数据库方面的知识多多指教

1 楼 mikixiyou 2012-06-13  

你这里给用户授予的权限太多，一般只要connect,resource，足够。