Overview
Editing a Database Role
Overview
Roles are a powerful tool that allow you to collect users into a single unit
against which you can apply permissions. Permissions granted to, denied to, or
revoked from a role also apply to any members of the role. You can establish a
role that represents a job performed by a class of workers in your organization
and grant the appropriate permissions to that role. As workers rotate into the
job, you simply add them as a member of the role; as they rotate out of the job,
remove them from the role. You do not have to repeatedly grant, deny, and revoke
permissions to or from each person as they accept or leave the job. The
permissions are applied automatically when the users become members of the role.
Editing a Database Role
You may add or remove database users to or from a database role. System database roles consist
of read only properties that you may not change. User defined database roles can not be created
using this tool.
|
