on 07-24-2013 6:12 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.