Oracle 用户的操作

1.创建用户

SQL> create user jack identified by jack;

2.修改密码

SQL> alter user jack identified by rose;

3.授权用户

SQL> grant dba,resource,connect to jack;  

4.收权限

SQL> revoke dba from jack;

5.锁定用户

SQL> alter user jack account lock;

SQL> alter user jack account unlock;(解锁)

6.权限传递(此用户拥有创建dba权限)

SQL> grant dba to jack with admin option;

7.给用户指定表空间及可用大小
SQL> alter user jack default tablespace testspace quota 3m on testspace;

8.查看当前用户
SQL> select user from dual;    或者   show user;