《Oracle 11g数据库编程入门与实战》习题答案 第九章

第九章 数据库用户及安全管理

1．

--1)

SQL> conn sys/oracle as sysdba

SQL> CREATE USER doctor

IDENTIFIED BY doctor

DEFAULT TABLESPACE users

TEMPORARY TABLESPACE temp

QUOTA 10M ON users;

--2)

SQL> SELECT * FROM dba_users WHERE username = 'DOCTOR';

--3)

SQL> SELECT * FROM DBA_TS_QUOTAS

WHERE username = 'DOCTOR';

--4)

--在用户DOCTOR能够登陆之前，必须由管理员赋予创建会话的权限：

SQL> GRANT CREATE SESSION TO doctor;

SQL> conn doctor/doctor

SQL> ALTER USER doctor IDENTIFIED BY jenny;

--5)

SQL> conn sys/oracle as sysdba

SQL> DROP USER doctor;

2．

--1)

SQL> conn system/oracle

SQL> CREATE USER donna

IDENTIFIED BY noble

DEFAULT TABLESPACE data

TEMPORARY TABLESPACE temp

QUOTA 1M ON data;

--2)

SQL> GRANT CREATE SESSION, CREATE TABLE TO donna;

SQL> conn scott/tiger

SQL> GRANT SELECT ON emp TO donna;

--3)

SQL> conn donna/noble

SQL> CREATE TABLE EMPLOYEES AS SELECT * FROM scott.emp;

--4)

SQL> conn donna/noble

SQL> GRANT INSERT ON donna.employees TO system

WITH GRANT OPTION;

SQL> conn system/oracle

SQL> GRANT INSERT ON donna.employees TO scott;

--5)

SQL> conn scott/tiger

SQL> INSERT INTO donna.employees(empno, ename)

VALUES(1234, 'Jones');

--6)

SQL> SELECT * FROM dba_tab_privs

WHERE grantee = 'DONNA' OR grantor = 'DONNA';

3．

--1)

SQL> conn system/oracle

SQL> SELECT * FROM dba_sys_privs

WHERE grantee= 'RESOURCE';

--2)

SQL> CREATE ROLE Manager;

SQL> GRANT CREATE TABLE, CREATE VIEW TO Manager;

SQL> conn scott/tiger

SQL> GRANT SELECT ON scott.dept TO manager;

--3)

SQL> conn system/oracle

SQL> GRANT connect, resource, manager TO donna;

SQL> ALTER USER donna DEFAULT ROLE resource;

--4)

SQL> conn donna/noble

SQL> GRANT SELECT ON employees TO system;

SQL> conn system/oracle

SQL> CREATE VIEW donna_emp

AS SELECT * FROM donna.employees;

4．

--1)

SQL> CREATE PROFILE manager_profile LIMIT

FAILED_LOGIN_ATTEMPTS 3

PASSWORD_LIFE_TIME 30

PASSWORD_REUSE_TIME 90;

--2)

SQL> ALTER USER donna PROFILE manager_profile;

--3)

--连续三次输入错误口令

SQL> conn donna/aa

SQL> conn donna/bb

SQL> conn donna/cc

--输入正确口令

SQL> conn donna/noble

ERROR：

ORA-28000: the account is locked

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11168/viewspace-1035533/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11168/viewspace-1035533/