創(chuàng)建用戶

create user username

identified by username

default tablespace tablespace_name;

授予一般權(quán)限

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權(quán)限

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;

總結(jié)

以上是生活随笔為你收集整理的oracle常用用户权限,oracle创建新用户及授予常用权限的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。