The syntax for granting privileges in PostgreSQL is:

GRANT [privilege_type] ON [object_name] TO [username];

For example, to grant SELECT privilege on a table named ‘customers’ to a user named ‘user1’, the command would be:

GRANT SELECT ON customers TO user1;

Leave a Reply

Your email address will not be published. Required fields are marked *