Database view access for a new role.

[pattipdx]

Hi SN community,

I have one DBA on staff that will be creating database views for our mobile device management.

I don't want to give him full admin access. I have created a new role "database_view_admin".

I added "database_view_admin" to the Application Menu > System Definition role, however when I impersonate him I don't see the menu item and cannot access Database Views.

What am I missing?

Best regards,

Patti

[jcraneNYC]

You need to pull up Database Views, and select Personalize -> Security Rules. Modify the Read and Write ACLs to allow the new role.

I'd be more curious to hear about your use case for this. Database Views simply join 1 or many tables in ServiceNow, mostly for reporting purposes. What are you trying to accomplish here?

[pattipdx]

Hi Jon,

Thanks for your quick reply. I can see the link now by adding the role to Module > Database Views

I will try the ACL permission.

Use case

My DBA is using 4 tables to cross reference mobile devices (user / asset status / manufacturer   / os etc).

I created the first DB View for him and then I added a filter to the web service url to show only certain kinds of communication assets. It is a nice module.

Best regards,
Patti