1

I want to create a user that only have read privileges on tables. The trick is alter default_transaction_read_only parameter:

create user 'readonly' password 'anypass';
alter user readonly set default_transaction_read_only = on;

Next, there are n schemes in my databases, How can I give give permission to all tables in every scheme?

Thanks in advance

2
  • 1
    That won't help, the user can change the the setting default_transaction_read_only without any problems.The only safe way to do this is to revoke all update privileges from the user. Commented Jun 18, 2015 at 11:39
  • Another question that might help: dba.stackexchange.com/questions/35316/… Commented Jun 18, 2015 at 11:41

0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.