GRANT privileges ON object TO user;

privileges

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • REFERENCES
  • ALTER
  • INDEX
  • ALL

object

  • database object that you are granting privileges for. In the case of granting privileges on a table, this would be the table name.

user

  • the name of the user that will be granted these privileges.

 

Examples:

GRANT SELECT, INSERT, UPDATE, DELETE ON object_name TO user_name;
GRANT ALL ON object_name TO user_name;
GRANT SELECT ON object_name TO user_name;

 

Vlastimil Pošmura, 2019