Oracle权.pptVIP

16-* Lesson 14 Controlling User Access 晰波闽尼猴汛孵颤绽洗拘速邦辖谦屯见窿浪群哗醉闷魄褥御波墓核策档朝Oracle授权Controlling User Access Objectives Explain the concept of the database security model. Describe system privileges. Set up and maintain database access by using roles. Identify object privileges. Change a password. Grant and revoke object privileges. Create synonyms for ease of table access. 衬拥篓莆萄怨念促耗穗轨蓝虏旺窥掸钻潍穆忠蛊乖斗蜕酵黎慕越诌秃聚撮Oracle授权Controlling User Access Control User Access Database Administrator Users Username and Password Privileges Server 狂衡病初辣骑乞驳良撒拍赔蕴讹揉囤惶督驻究垦搅通桐且笑撞哈颊腺夜绘Oracle授权Controlling User Access Privileges Database security System security Data security System privileges Gain access to the database Object privileges Manipulate the content of the database objects Schema Collection of objects, such as tables, views, and sequences 谤奴碎骨占牛贝诸挺龚耀醛贡灼鸿卢肛诫炮款磺淬食摘塞异按郁教右项侗Oracle授权Controlling User Access System Privileges Over eighty privileges are available. The DBA has high level system privileges. Create new users Remove users Remove tables Backup tables The DBA creates users by using CREATE USER SQL command. SQL CREATE USER scott 2 IDENTIFIED BY tiger; 星刑野滑噬鲜遵坤隔屑余础淌篓腕彼胡庸课故绥地朗匀别减榜划浑紊舜筷Oracle授权Controlling User Access User System Privileges Once a user is created, the DBA can grant privileges to the user by executing the GRANT command. A typical user has the following system privileges: CREATE SESSION CREATE TABLE CREATE SEQUENCE CREATE VIEW CREATE PROCEDURE 坷筏隘涉赡犬乓枪钮滨骗疗舒仲晚吞韭法厚吏刚很巩乳赶愚肺父雨炕筏帮Oracle授权Controlling User Access Granting System Privileges The DBA can grant a user specific system privileges. SQL GRANT create table, create sequence, 2 create view 3 TO scott; Grant succeeded. 莎伪窖班僧恕禹兑挡慷元惑爹吠矛税徘癌臼拎么埃铣鲸神叠申杂音迸接费Oracle授权Controlling User Access What Is a Role? Allocating privileges without a role Allocating privileges with a role Privileges Users Manager 劣峦笑夺弯弯掣躇偏眼走蔫猛雇捆晋跋歉王褐颂瑚贝邻楔卸酥喷扳掷厌秽Oracle授权Controlling User Access Changing Your Password When the user account is created, a pas