oracle授予数据库所有权限,oracle创造新用户及授予常用权限

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;

1 楼

mikixiyou

2012-06-13

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

2 楼

michael8335

2012-06-13

mikixiyou 写道

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

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