DBA Hub

📋Steps in this guide1/1

REVOKE privilege commands

Examples on REVOKE command

postgresql configurationintermediate
by MYSQL
15 views
1

REVOKE privilege commands

Examples on REVOKE command for more commands: use the help command

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
REVOKE CONNECT ON DATABASE PRIMDB FROM DBAUSER1;
REVOKE USAGE ON SCHEMA CRM FROM DBAUSER1;
REVOKE INSERT,UPDATE,DELETE ON TABLE CRM.EMPTAB FROM DBAUSER1;
REVOKE ALL ON TABLE CRM.EMPTAB FROM DBAUSER1;
REVOKE CREATE ALL ON DATABASE CRM FROM DBAUSER2;
REVOKE CREATE ON TABLESPACE INV_TS FROM DBAUSER2;
REVOKE ALL ON TABLESPACE INV_TS FROM DBAUSER2;
REVOKE CREATE ON TABLESPACE INV_TS FROM DBAUSER2 ;
REVOKE EXECUTE ON PROCEDURE PRIM_ID.TEST_PROC FROM DBAUSER2;
REVOKE EXECUTE ON FUNCTION PRIM_ID.TEST_FUNC FROM DBAUSER2;
#\h REVOKE

Comments (0)

Please to add comments

No comments yet. Be the first to comment!