(â ) Database management privileges
GRANT CREATE DATABASE ON DBMS TO my_role
Grant the privilege to create databases to a role.
REVOKE DENY DROP DATABASE ON DBMS FROM my_role
Revoke the denied privilege to delete databases from a role.
DENY DATABASE MANAGEMENT ON DBMS TO my_role
Deny all privileges to manage database to a role.
Comments