Mongodb grant readwrite how to#
Some examples to understand how to grant table privileges in PostgreSQLįor example, if you want to grant SELECT, INSERT, UPDATE, and DELETE privileges to a table named products for a user named trizor, you must run the following GRANT statement: user – The name of the user to whom these privileges will be granted.In case you grant privileges for a table, this will be the name of the table. object – The name of the database object for which you grant privileges.This can be any of the following values:Ībility to execute SELECT operators for a table.Ībility to execute INSERT operators for a table.Ībility to execute UPDATE operators for a table.Ībility to execute DELETE operators for a table.Ībility to execute TRUNCATE operators on a table.Ībility to create external keys (requires privileges for both parent and child tables).Ībility to perform CREATE TABLE operators. Syntax to provide table privileges in PostgreSQL These permissions can be any combination of SELECT, INSERT, UPDATE or DELETE, INDEX, CREATE, ALTER, DROP, GRANT OPTION, or ALL. You can give users different privileges for tables.
PostgreSQL DBA: Grant and Revoke Privileges in PostgreSQL.Examples of how to revoke privileges for a table in PostgreSQL.The syntax for revoking table privileges in PostgreSQL.Some examples to understand how to grant table privileges in PostgreSQL.Syntax to provide table privileges in PostgreSQL.
0 kommentar(er)
