Database view access for a new role.

pattipdx
Tera Contributor

‎08-11-2014 09:53 AM

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

0 Helpfuls
  • 5,175 Views
2 REPLIES 2

jcraneNYC
ServiceNow Employee
ServiceNow Employee

‎08-11-2014 09:56 AM

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
Tera Contributor
In response to jcraneNYC

‎08-11-2014 10:07 AM

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


0 Helpfuls