I have a database where 'public' has all permissions in the database.
However I would like to grant only 'select' permissions on the tables in the database to a 'user1'. How do I do this with just one command line?

I know 'grant select on <table> to 'user1' does this but it has to be repeated for all the tables and I do not want to this way.

Please suggest a better command I can use once at the database level for the user to grant 'select' permissions.

Thanks

Try this meta SQL statement:


output to "grant_select.sql" without headings
select "grant select on " || trim(st.tablename) || " to user1;"
from systables st
where tabid > 99
and tabtype = "T";