sqlplus /nolog
SQL>conn /as sys
CREATE USER "TEST" PROFILE "DEFAULT"
IDENTIFIED BY "test" DEFAULT TABLESPACE "TEST" ;
grant connect,resource,dba to "someuser" with admin option;
查看當前用戶的缺省表空間
SQL>select username,default_tablespace from user_users;
查看當前用戶的角色
SQL>select * from user_role_privs;
查看當前用戶的系統權限和表級權限
SQL>select * from user_sys_privs;
SQL>select * from user_tab_privs;
查看所有用戶
SQL>select username from all_users;
posted on 2009-03-10 15:58
周銳 閱讀(182)
評論(0) 編輯 收藏 所屬分類:
Oracle