When Creating a custom security role, what privileges do I need to add to it, in order for the users that I grant him the role, to be able to use
dynamic SQL to perform read only queries on all tables in a namespace?
I have a security role, that contains the %Service_SQL privilege,
And yet when I connect to a terminal and try to run an SQL query using dynamic SQL , I get a "user is not privileged for the operation" error.
reading the documentation , I understand that %Service_SQL privilege privilege is not enough, but I don't understand what privilege to add,
I can't add specific tables in the "SQL Tables" section of the role definition, I need all the tables to be accessible.
this the documentation I mentioned: