Role Name

You can use the GRANT statement to associate a list of one or more users (or all users, using the PUBLIC keyword) with a role name that can describe what they do. After you declare and grant a role, access privileges that you grant to that role are thereby granted to all users who are currently associated with that role.

Role Name

1 role
1 'role'
Element Description Restrictions Syntax
role Role that is granted, or to which a privilege or another role is granted Must exist. If enclosed between quotation marks, role is case sensitive. Owner name

You can also grant an existing role to another role. This action gives whatever privileges the granted role possesses to all users who have the receiving role.