Oracle教程08.pptVIP

第八章 管理特权 系统特权 SYSDBA和SYSOPER 对象特权 系统特权 授予系统特权 收回系统特权 显示系统特权信息 DBA_SYS_PRIVS SESSION_PRIVS SYSDBA和SYSOPER 对象特权 对象特权 表 视图 序列 过程 ALTER DELETE EXECUTE INDEX INSERT REFERENCES SELECT UPDATE 授予对象特权 收回对象特权 显示对象特权信息 DBA_TAB_PRIVS DBA_COL_PRIVS 练习八 wanghailiang * 种类 例子 INDEX CREATE ANY INDEX ALTER ANY INDEX DROP ANY INDEX TABLE CREATE TABLE CREATE ANY TABLE ALTER ANY TABLE DROP ANY TABLE SELECT ANY TABLE UPDATE ANY TABLE DELETE ANY TABLE SESSION CREATE SESSION ALTER SESSION RESTRICTED SESSION TABLESPACE CREATE TABLESPACE ALTER TABLESPACE DROP TABLESPACE UNLIMITED TABLESPACE GRANT CREATE SESSION, CREATE TABLE TO peter; GRANT CREATE SESSION TO scott WITH ADMIN OPTION; REVOKE CREATE TABLE FROM peter; REVOKE CREATE SESSION FROM scott; SYSOPER STARTUP SHUTDOWN ALTER DATABASE OPEN | MOUNT ALTER DATABASE BACKUP CONTROLFILE ALTER TABLESPACE BEGIN/END BACKUP  RECOVER DATABASE, ALTER DATABASE ARCHIVELOG RESTRICTED SESSION SYSDBA SYSOPER privileges WITH ADMIN OPTION CREATE DATABASE RECOVER DATABASE UNTIL REMOTE_LOGIN_PASSWORDFILE GRANT EXECUTE ON dbms_pipe TO public; GRANT UPDATE(ename,sal) ON emp TO peter WITH GRANT OPTION; REVOKE execute ON dbms_pipe FROM scott; 建立用户kay，并授予登录和建表特权 以kay登录，运行脚本lab10_1.sql建表EMP和DEPT 以SYSTEM用户登录，将查询KAY.EMP权限授予用户BOB？ 以KAY用户登录，将查询EMP权限授予用户BOB 显示BOB用户的对象和系统特权 授予KAY用户启动和关闭数据库的特权 wanghailiang