This article contains information about revoke command usage in PostgreSQL. You may want to revoke permissions of users. In this case, you can use the plpgsql commands below. First, let’s see the sytanx and then the examples.<\/p>\n
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM username;\nREVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public FROM username;\nREVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public FROM username;<\/pre>\nIn the example below, we use the following commands to revoke f_user’s all the permissions in table sequences and functions.<\/p>\n
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA Personel_tablosu FROM f_user;\nREVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA publicsemasi FROM\u00a0 f_user;\nREVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA publicsemasi FROM\u00a0 f_user;<\/pre>\nWe can use the command below to revoke create permission on the schema.<\/p>\n
REVOKE CREATE ON SCHEMA public FROM PUBLIC;<\/pre>\nWith the help of the command below, we will revoke the select, insert, update, delete permission on the products table from f_user.<\/p>\n
Revoke Select Permission from user:<\/strong><\/p>\n
REVOKE SELECT ON products TO f_user;<\/pre>\nRevoke Insert Permission from user:<\/strong><\/p>\n
REVOKE INSERT ON products TO f_user;<\/pre>\nRevoke Update Permission from user:<\/strong><\/p>\n
REVOKE UPDATE ON products TO f_user;<\/pre>\nRevoke Delete Permission from user:<\/strong><\/p>\n
REVOKE DELETE ON products TO f_user;<\/pre>\nTo revoke the permissions such as select and insert in the same script, you can edit and run the command by seperating permissions with a comma as follows.<\/p>\n
REVOKE SELECT, INSERT ON products TO f_user;<\/pre>\n<\/div>\n