Useful SQL Statements (cont.)

• Create role rolename; (creates an access role)

• Drop role rolename; (deletes role)

• Grant SELECT,INSERT,UPDATE,DELETE on object to role; (grants specific object privileges to role)

• Grant rolename to userid; (grants role to user)

• Revoke rolename from userid; (removes role privilege from user)

Previous slide

Next slide

Back to first slide

View graphic version