REVOKE Credential Permission

Permissions on credentials that have been granted directly to users or roles can be revoked.

REVOKE Credential Permission Syntax

REVOKE <READ | ADMIN> [PRIVILEGES]
ON <ALL CREDENTIALS [IN [SCHEMA] <schema reference>] | CREDENTIAL <credential reference>>
FROM <user name | role name>

REVOKE Create Credential Permission Syntax

REVOKE CREATE [PRIVILEGES] ON CREDENTIALS
[IN [SCHEMA] <schema reference>]
FROM <user name | role name>

Examples

To revoke read access on the credential named auser_azure_active_dir_creds from the auser user:

REVOKE Credential Use Permission Example

REVOKE READ ON CREDENTIAL auser_azure_active_dir_creds FROM auser

To revoke administrative access on the credential from the auser user:

REVOKE Credential Administrative Permission Example

REVOKE ADMIN ON CREDENTIAL auser_azure_active_dir_creds FROM auser

​Examples

Examples