用户权限角色.pptxVIP

Qualityisnotanact!It`sahabit.

Objectives

Aftercompletingthislesson,youshouldbeableto

dothefollowing:

Createusers(创建用户)

Createrolestoeasesetupandmaintenanceofthesecuritymodel(创建角色)

UsetheGRANTandREVOKEstatementstograntandrevokeobjectprivileges(授予和回收权限)

Qualityisnotanact!It`sahabit.

ControllingUserAccess

(控制用户概述)

Database

administrator

Users

Usernameandpassword

Privileges

Qualityisnotanact!It`sahabit.

CreatingUsers(创建用户)

TheDBAcreatesusersbyusingtheCREATEUSERstatement.

CREATEUSERscott

IDENTIFIEDBYtiger;

Usercreated.

CREA