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
Stefan