How to give users permission to query tables

Question

Question

Zhang Fatong · Dec 17, 2023

#InterSystems IRIS #InterSystems IRIS for Health

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)1

Log in or sign up to continue

Pierre LaFay · Dec 18, 2023

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)

0 0

score 0 · Answer 1 · 2023-12-17T22:10:28-05:00

Zhang Fatong · Dec 17, 2023

I would like to use the jdbc method for querying. Is there any good way to do so

0 0

score 0 · Answer 2 · 2023-12-18T05:19:27-05:00

Zhang Fatong · Dec 18, 2023

Thank you very much. He has been very helpful to me

0 0