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 

[johnfeist]

Two things to check.  First make sure that you don't have any table specific ACLs (e.g. for incident) as those will be applied over ones with Name = *.  Also make sure that you have assigned the correct role to the user id you are using for testing.

:{)

[Anurag Tripathi]

Hi,

The most usual way to do this is by giving one 'admin' access along with 'snc_read_only' role. This will give one a universal read only access also referred to as 'Auditor Access'.

-Anurag

[Rameshnathan]

Hi All.

if I am giving one 'admin' access along with 'snc_read_only' role means all the tables are changed to read-only but my scenario some of the fields should able to edit.

Thanks

Ramesh R

[DirkRedeker]

Hi Did you try the 'snc_read_only' role? Doesn't that meet your expectations? Let me know, if that does not fit, and I try to investigate further. BR Dirk