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
周锐 阅读(179)
评论(0) 编辑 收藏 所属分类:
Oracle