You can translate the question and the replies:

Revoke multiple privileges in one query.

Hello. Is it possible to GRANT/REVOKE acces to multiple objects in a database without havin to list all identifiers? Perhaps using wildcards or parameterized query? Regards Martin
GRANT REVOKE
user
16-11-2020 09:12:16 -0500
code

1 Answer

Hi, It is possible to use VQL commands GRANT/ REVOKE to modify multiple/ all the privileges of a user(s) and if you would want to parameterize the inputs you can do that by creating a JDBC data source against the Virtual DataPort and creating a base view using 'Create from query' option by using interpolation variables that you can be passed during execution. For detailed information, you can refer to the [Execution Context of a Query and Interpolation Strings](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/advanced_characteristics/execution_context_of_a_query_and_interpolation_strings/execution_context_of_a_query_and_interpolation_strings) section of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
18-11-2020 07:23:50 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here