Removes a previously granted or denied privilege.

Syntax

REVOKE [GRANT OPTION FOR]
cirroPrivilege,...
[ON securable]
FROM {username | rolename};

Arguments

  • GRANT OPTION - the ability to grant the stated privilege(s) to another user or role.

  • cirroprivilege - a privilege on a supported securable.

  • securable - A supported securable. If omitted, the privilege is applied to all available datasources.

  • username - Cirro user account name. Can be internal to CIRRO or an external Directory Service user.

  • rolename - Cirro Role.

Additional Information

  • If this principal has cirroPrivilegeType on the securable but not the GRANT OPTION, the privilege itself will be revoked.

  • If no granted or denied privilege exists at this level, the command does nothing.

Examples

Revoke the Create System privilege on all datasources from a user.

REVOKE CREATE SYSTEM ON * FROM myUser1 ;

Revoke the Select privilege on a datasource from a role.

REVOKE SELECT ON Oracle1.Accounting2016DB.* FROM accountingUsersRole;

See Also