第 4章.txt

oracle操作基础基础基础基础基础基础基础基础基础基础基础基础

例4.1 
connect system/system@oradb;
DROP USER stu08 CASCADE;
CREATE USER stu08 IDENTIFIED BY stu08
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP;
DROP USER stu08_1 CASCADE;
CREATE USER stu08_1 identified by stu08_1;
DROP ROLE r08;
CREATE ROLE r08;

例4.2 
conn system/system@oradb
GRANT CREATE SESSION,CREATE TABLE TO stu08_1;
GRANT CREATE SESSION, CREATE TABLE, DBA TO stu08;

例4.3 
connect stu08/stu08@oradb;
DROP TABLE tab08;
CREATE TABLE tab08(
  name varchar2(20),
  age number(3));
CREATE SYNONYM sy_tab08 FOR tab08;
CREATE PUBLIC SYNONYM sypub_tab08 FOR tab08;

例4.4 
conn stu08/stu08@oradb
GRANT INSERT,SELECT ON tab08 TO scott, r08;
GRANT r08 TO stu08_1;
INSERT INTO sy_tab08 VALUES('zhangsan',18);
INSERT INTO sy_tab08 VALUES('lisi',20);
commit;
UPDATE stu08.tab08 SET age=20;
DELETE FROM stu08.tab08 WHERE name='zhangsan';
commit;
INSERT INTO stu08.tab08 VALUES('caochao',20);
commit;
SELECT * FROM stu08.tab08;
UPDATE stu08.tab08 SET age=20;
DELETE FROM stu08.tab08 WHERE name='zhangsan';
commit;
INSERT INTO stu08.tab08 VALUES('libai',19);
commit;
SELECT * FROM stu08.tab08;

例4.5
conn hr/hr@oradb
GRANT UPDATE(EMPLOYEE_ID,FIRST_NAME, LAST_NAME)
ON employees
TO scott WITH GRANT OPTION;
SELECT * FROM USER_COL_PRIVS_MADE;
conn scott/tiger@oradb
SELECT * FROM USER_COL_PRIVS_RECD;
conn hr/hr@oradb
REVOKE UPDATE ON employees FROM scott;