Skip to Content
0
Jun 28, 2016 at 09:35 AM

Grant SELECT on all tables from a schema to role?

16260 Views

Hello community,

do you know if it's possible to grant SELECT privileges on all tables from a distinct schema (or the whole db) to a role?
It would be nice to have something like a "read only" user for the whole database, just in case you want to look up a data set without accidently editing anything.

All the solutions I found don't match with the possible SQL syntax for HANA and system privileges like catalog_read don't provide the same possibilities.

Thank you.