How to give read access only for all the table

[Rameshnathan]

Hi All,

I have to give read-only access to all the tables and write access for a few tables, please guide me on how to achieve this.

Example: if ServiceNow has 100 table means 90 tables read only 10 tables write access

but it should not use the 'admin' role

Thanks

Ramesh 

[DirkRedeker]

Hi Please have a look at the 'snc_read_only' role. That is exactly what you want. Let me know and mark my answer as correct or helpful. BR Dirk

[johnfeist]

Hi Ramesh,

The simplest thing is to define a group where all members will have those rights.  Create a role and assign it that group.  You can probably figure out a script to do the membership assignment.

You also need to create a lot of ACLs so that you will have the ninety read only ACLs where anyone who has the role described above gets access.  You need to also create read and write ACLs for the other ten with the same criteria.

Hope that helps.

:{)

[H_Halim1]

Hello,

As mentioned by Dirk, you can use the snc_read_only role if you intend to limit the write/update access for users that already have access to those tables.

Otherwise, if you're want to give read access to all tables for all user by default, you may need to create 2 read ACLs, one for "*" (all records on all tables) and one for "*.*" (all fields on all tables)

[Rameshnathan]

Hi 

I created ACL like this below but no luck 

Out put