Role Management Commands

Note

For details on specific commands, including syntax and examples,click on the specific command to go to its reference page.

NameDescription
createRoleCreates a role and specifies its privileges.
dropRoleDeletes the user-defined role.
dropAllRolesFromDatabaseDeletes all user-defined roles from a database.
grantPrivilegesToRoleAssigns privileges to a user-defined role.
grantRolesToRoleSpecifies roles from which a user-defined role inherits privileges.
invalidateUserCacheFlushes the in-memory cache of user information, including credentials and roles.
revokePrivilegesFromRoleRemoves the specified privileges from a user-defined role.
revokeRolesFromRoleRemoves specified inherited roles from a user-defined role.
rolesInfoReturns information for the specified role or roles.
updateRoleUpdates a user-defined role.