|Lesson 11||Deleting a role |
|Objective||Drop role from the database.|
Drop role from Database
A role is a type of database object. You remove it from the database by dropping it.
Drop role Syntax
To remove a role from the database, you use the SQL command illustrated in the following MouseOver.
DROP ROLE rolename
- The DROP ROLE keyword phrase is required.
- The name of an existing role.
Consequence of Dropping Role
Once a role is dropped, it is automatically removed from all users who have access to the role. Any future reference to the role in a
SET ROLE statement will return an error.
If you create a role with the same name at a later time, you must re-grant privileges to the role and re-grant the role to other users and roles.
To remove the role
BIDDER from the database, use the following command:
DROP ROLE BIDDER;
The command must be issued by either the owner of the role or a user who had been granted the role with the
ADMIN OPTION. The next lesson is the module wrap-up. You can take a quiz to see what you learned and discover topics that you might want to review.