In today’s article, we will learn how to define and get privileges such as Select, Insert, Update and Delete to specific tables in a Postgresql database.
Define Privileges
If you are dealing with database management, there may be times when you want to access only one view or only one table in a database.
In such cases, permissions are defined only for the relevant object with the help of the GRANT command.
Syntax:
|
1 |
GRANT SELECT, INSERT, UPDATE, DELETE TO user_name; |
For example, let’s define select permission to the Faruk user in our students table.
|
1 |
GRANT select ON ogrenciler TO faruk; |
For example, let’s define insert permission to the Faruk user in our students table.
|
1 |
GRANT insert ON ogrenciler TO faruk; |
For example, let’s define update permission to the Faruk user in our students table.
|
1 |
GRANT update ON ogrenciler TO faruk; |
For example, let’s define delete permission to the Faruk user in our students table.
|
1 |
GRANT delete ON ogrenciler TO faruk; |
Get Privileges
|
1 |
GRANT SELECT,INSERT,UPDATE,DELETE TO user_name; |
For example, let’s get select permission to the Faruk user in our students table.
|
1 |
REVOKE select ON ogrenciler FROM faruk; |
For example, let’s get insert permission to the Faruk user in our students table.
|
1 |
REVOKE insert ON ogrenciler FROM faruk; |
For example, let’s get update permission to the Faruk user in our students table.
|
1 |
REVOKE update ON ogrenciler FROM faruk; |
For example, let’s get delete permission to the Faruk user in our students table.
|
1 |
REVOKE delete ON ogrenciler FROM faruk; |
You can use the revoke sentence below to get all the permissions.
|
1 |
REVOKE select,insert,update,delete ON ogrenciler FROM faruk; |
