How can I create a set of PGSQL env keys that are read only?
Hello!
I want to create a set of keys that will be used for read only operations only without any write permissions, is that possible?
Thanks π
4 Replies
Create a read only user and then add the envs to your service π
Stack Overflow
How do you create a read-only user in PostgreSQL?
I'd like to create a user in PostgreSQL that can only do SELECTs from a particular database. In MySQL the command would be:
GRANT SELECT ON mydb.* TO 'xxx'@'%' IDENTIFIED BY 'yyy';
What is the
ezpz
Ooh perfect, thanks a ton!