DBA Hub

📋Steps in this guide1/1

GRANT privilege commands

Examples on GRANT command

postgresql configurationintermediate
by PostgreSQL
14 views
1

GRANT privilege commands

Examples on GRANT command

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
GRANT CONNECT ON DATABASE PRIMDB to DBAUSER1;
GRANT USAGE ON SCHEMA CRM to DBAUSER1;
GRANT INSERT,UPDATE,DELETE ON TABLE CRM.EMPTAB TO DBAUSER1;
GRANT ALL ON TABLE  CRM.EMPTAB TO DBAUSER1;
GRANT CREATE ALL ON DATABASE CRM to DBAUSER2;
GRANT CREATE ON TABLESPACE INV_TS to DBAUSER2;
GRANT ALL ON TABLESPACE INV_TS TO DBAUSER2;
GRANT CREATE ON TABLESPACE INV_TS to DBAUSER2 with grant option:
GRANT EXECUTE ON PROCEDURE PRIM_ID.TEST_PROC;
GRANT EXECUTE ON FUNCTION PRIM_ID.TEST_FUNC;
for more commands: use the help command
#\h GRANT

Comments (0)

Please to add comments

No comments yet. Be the first to comment!