Difference between revisions of "PostgreSQL read only user"

From wikieduonline
Jump to navigation Jump to search
 
Line 3: Line 3:
 
* <code>[[GRANT CONNECT on database]] YourDB to my_[[readonly]];</code>
 
* <code>[[GRANT CONNECT on database]] YourDB to my_[[readonly]];</code>
 
* <code>[[GRANT]] [[pg_read_all_data]], [[pg_monitor]] TO my_readonly;</code>
 
* <code>[[GRANT]] [[pg_read_all_data]], [[pg_monitor]] TO my_readonly;</code>
 +
 +
 +
select * from your_table;
 +
value
 +
-------
 +
(0 rows)
 +
  
 
== Related ==
 
== Related ==

Latest revision as of 11:17, 23 September 2024

Advertising: