Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 9. Database Security > Roles
Roles
A role is a group of privileges that you can assign to a user or another role. The following points summarize the benefits of roles:
Rather than assigning privileges one at a time directly to a user, you can create a role, assign privileges to that role, and then grant that role to multiple users and roles.
When you add or delete a privilege from a role, all users and roles assigned that role automatically receive or lose that privilege.
You can assign multiple roles to a user or role.
You can assign a password to a role.
