How to give users permission to query tables
I have created a delegated user and I want to use this user to query some tables. When I grant the role of% ALL, I can query tables, but I cannot grant% ALL. I want this user to only have the permission to query tables. What should I do
Product version: IRIS 2020.1
Discussion (3)0
Comments
I would like to use the jdbc method for querying. Is there any good way to do so
Hi Zhang,
In the portal : System/Security/Roles you can create your own role like "myUserRole".
When created you have in the role definition a tab "Sql Tables".
In this tab you can add the tables which the role can access.
If you assign the created role to a user, he can access the tables.
hardcopy of the Sql Tables Tab in System/Security/Roles (in french)
Thank you very much. He has been very helpful to me