REVOKE Privileges from User using DQL

Below are Privileges which can be used in the query

• SUPERUSER
• SYSADMIN
• CREATE TYPE
• CREATE CABINET
• CREATE GROUP
• CONFIG AUDIT
• PURGE AUDIT
• VIEW AUDIT

 

Below is the query to Revoke privileges from User.

 

Syntax

REVOKE <PRIVILEGES> FROM <USER NAME>,<USER NAME>

or 

REVOKE <PRIVILEGES>,<PRIVILEGES> FROM <USER NAME>,<USER NAME>

or 

REVOKE <PRIVILEGES> FROM (<QUERY>)

or 

REVOKE <PRIVILEGES>,<PRIVILEGES> FROM (<QUERY>)

 

Example

REVOKE CREATE TYPE FROM DCTMAdmin

or

REVOKE CREATE TYPE FROM (select user_name from dm_user where user_login_name = 'dctmadmin')



REVOKE CREATE TYPE,CREATE GROUP FROM DCTMAdmin

or

REVOKE CREATE TYPE,CREATE GROUP FROM (select user_name from dm_user where user_login_name = 'dctmadmin')