sqlplus / as sysdba
CREATE USER new_sys_user IDENTIFIED BY password;创建用户
GRANT DBA TO new_sys_user;指定权限
select * from dba_user;查看DBA用户权限
select * from all_users;查看所有用户权限
select * from user_users;查看当前用户权限
SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'HR';查看指定用户（HR）权限
|