本文共 1493 字，大约阅读时间需要 4 分钟。

Oracle?????????

1. ??????

1.1 ??????

????????????????????????????????????????

SQL> grant connect, resource to user50;

1.2 ??????

??????????????????

SQL> select * from dba_role_privs;SQL> select * from dba_sys_privs;SQL> select * from role_sys_privs;

1.3 ??????

??????????????????

SQL> drop user user50 cascade;

2. DBA????

2.1 ??DBA??

????????DBA??????

SQL> grant dba to user50;

2.2 ??DBA??

???DBA????????????

SQL> revoke dba from user50;

3. Oracle????

3.1 ????

????????????????????????????

SQL> create role role1;

3.2 ??????

????????

SQL> grant create any table, create procedure to role1;

3.3 ??????

???????

SQL> select * from role_sys_privs;

3.4 ????

??????????

SQL> drop role role1;

4. ???????

4.1 ???

???????????

SQL> create table stud02.product(  id number(10),  name varchar2(20));

4.2 ???

?????????

SQL> create table stud02.employee as select * from scott.emp;

4.3 ?????

??????????????????

5. ????

5.1 ??????

???????

SQL> alter user acc01 identified by "12345";

5.2 ?????

????????

SQL> alter user acc01 default tablespace users;

5.3 ???????

??????????

SQL> alter user acc01 quota 50m on account;

6. ????

6.1 ??????

?????????

SQL> select username, sid, serial# from v$session;

6.2 ????

?????????

SQL> alter system kill session 'sid, serial#';

7. ????

7.1 ??????

?????????

SQL> select grantor, grantee, table_name, privilege from all_tab_privs;

7.2 ??????

?????????

SQL> select grantee, owner, table_name, privilege from user_tab_privs;

??

??????????????Oracle????????????????????????????