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;
查看當(dāng)前用戶的缺省表空間
SQL>select username,default_tablespace from user_users;
查看當(dāng)前用戶的角色
SQL>select * from user_role_privs;
查看當(dāng)前用戶的系統(tǒng)權(quán)限和表級(jí)權(quán)限
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
周銳 閱讀(185)
評(píng)論(0) 編輯 收藏 所屬分類:
Oracle