Revokes a database role from an account role or another database role.
GRANT DATABASE ROLE , GRANT ROLE , REVOKE ROLE , GRANT <privileges> … TO ROLE
REVOKE DATABASE ROLE <name> FROM { ROLE | DATABASE ROLE } <parent_role_name>
Copy
Parameters¶name
Specifies the identifier for the database role to revoke. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.
DATABASE ROLE parent_role_name
Revokes the database role from the specified database role.
ROLE parent_role_name
Revokes the database role from the specified account role.
REVOKE DATABASE ROLE analyst FROM ROLE SYSADMIN;
Copy
REVOKE DATABASE ROLE dr1 FROM DATABASE ROLE dr2;
Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4