Skip to Content
Former Member
Jul 24, 2013 at 05:12 AM

hdbrole including a whole schema as catalog object


Hello Colleagues,

i just started to play around with the hdbrole object and trying to include sql select persmissions to an whole schema, what is possible via SQL Statement. I tried it with several Statements, here onw example:

catalog sql object "<schema_name>"."*" : SELECT;

During activation i always get error.

Is it possible to grant sql statements to whole schemas (including all underlying tables) ?

If yes what is the syntax for achiving that ?

It would be great if somebody could help here.

Many thanks and best regards