Table Roles Queries

[kailashthiyagar]

I have created a new role and havent assigned anyone to that role. In the ACL of my table, i added the newly created role in the "Create Access" part. I removed the default role which has been created as well..

Q1:In this case when i go to my actual table data, i still see the new option over there.. I m d admin for my instance.. So does it show "New" option for me? But it shouldnt be.. Rit? Since only the members of newly created role should see the "New" option.. Right

Q2:

I have around 10 tables(9 Admin related tables and then one main form) for my application. When i created those tables, automatic ACL;s with the default role has been added. Now should i have go to individual ACL's in each table and have to add the newly created roles? Or do we have any better process of doing it?

[Pradeep Sharma]

Hello Kailash,

New option will be visible to everyone who was the write access to the table. If ACL has admin override checkbox set to true then ACL's wont be applicable to ADMINS.

Coming to second question..You can navigate to table "sys_security_acl_role.list" table to update new role to the ACL's created from the list view. This way you can update multiple records from list view.

http://wiki.servicenow.com/index.php?title=Editing_Lists#Editing_Multiple_Records

[kailashthiyagar]

pradeepksharmai removed the "Admin Override" option and i added my new role to the "Create" and "Add" ACL and also i removed the roles for "Delete/read" and made it as empty

Still as an admin, i could view it and i can see the option to create new..

[BALAJI40]

Hi Kailash,

First verify for other than admin and created role create access or not?

if other roles do not saw create new button,Then for admin again you need to change OOB acl,. For admin by default all table can access. so you need to update that acl by add condition in that acl by, current.sys_class_name!='tablename', then try and check.

https://your instance.service-now.com/sys_security_acl.do?sys_id=7c70e238c0a801667ce0c4a31fb1bf8f

[kailashthiyagar]

Thanks Balaji.. I do not want to mess up with admin role.

But this is what i did.

To the newly created role, i added my BA for read access only

I added the new created role to the application menu visibility as well

For all the other permission which got created my default, i removed the roles and made it as empty

I did impersonate as my BA, now i m able to see the menu option and my table and i could see the new button option as well..

I m missing something here but dont know what is that