New post
Question
· Dec 17, 2023

How to give users permission to query tables

#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