Database View access permissions to ITIL/non-admin user

[Hari krushna1]

Hi,

How can we give ITIL/non-admin user an authority to use Database Views.

Currently, user has only a read only access to DB views.

Any help is greatly appreciated.

Regards,
Hari

[Jaspal Singh]

Hi,

Database Views are vritual read-only tables. You can open it to be accessible (read-only) by modifying ACL of type read.

Are you looking for Write access? If so, it defeats the purpose of Database View which is supposed to be a virtual table that displays data using 2 or more tables.

[Community Alums]

Hi @Hari krushna ,

Create a read ACL directly on the database view table to allow non-admin/ ITIL users to view database view records.

How?

Type Access Control in the navigation filter.
Select the Access Control (ACL) module.
Select the New action at the top of the list.
Under Operation, select Read, and under Name, select the name of the database view i.e. Incident SLA
Add the required roles needed to access the database view and click Submit.

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[Community Alums]

Hi @Hari krushna ,

Glad to see my answer helped you, Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep