Jessica Richard написа:
Thanks!!!
"ALTER USER username SET default_transaction_read_only to true" worked.
One more question:
where do I see the current setting of "default_transacton_read_only (true for
false) for each user on the system? Is there a table that keeps this kind of info
for al
Thanks!!!
"ALTER USER username SET default_transaction_read_only to true" worked.
One more question:
where do I see the current setting of "default_transacton_read_only (true for
false) for each user on the system? Is there a table that keeps this kind of
info for all users?
Thanks again,
Jes
Milen A. Radev написа:
Jessica Richard написа:
I created a user and granted only "select" to this user so that this
user can only select the tables on a production system. But by
default, this user can also CREATE TABLE successfully
How can I revoke this "create table" privilege (and pos
Jessica Richard написа:
I created a user and granted only "select" to this user so that this user can
only select the tables on a production system. But by default, this user can also CREATE
TABLE successfully
How can I revoke this "create table" privilege (and possible others) and limit
