cancel
Showing results for 
Search instead for 
Did you mean: 

hdbrole including a whole schema as catalog object

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

vivekbhoj
Active Contributor
0 Kudos

Hi Stefan,

What code are you trying to execute?

You have to write:

catalog schema "Schemaname": SELECT;

This statement gives select privilege to whole schema.

If you want you can also add other SQL privileges like INSERT, UPDATE, DELETE.

Former Member
0 Kudos

Hello Vivek,

many thanks that syntax is working, i tried before in analogy to sql syntax with "catalog schema object .." which was not working.

Is it also possible to make the sql privileges grantable ?

BR

Stefan

vivekbhoj
Active Contributor
0 Kudos

Hi Stefan,

catalog sql object is used when you want to grant sql privilege on a particular object inside the schema.

For eg:

catalog sql object "SchemaName"."TableName": SELECT;

Is it also possible to make the sql privileges grantable ?

I don't know that but you can try once using WITH GRANT OPTION lke:

catalog schema "Schemaname": SELECT WITH GRANT OPTION;

and see if it works.


Answers (0)