Minimum permission to access all sys_properties table records

[rahul parshi]

Hi,

I am working on script where I need fetch all sys_properties table records using API. I was able to get this data only when admin permission was given.

But when I created custom role which had read/write permission to sys_properties table( I created access control for custom role), I was able to see only few of the records from table. 
I want to know what is minimum permission required to fetch all entries from sys_properties table without giving admin role.

Can anyone help me regarding same? and please let me know steps also to create any such custom role which can give access to sys_properties table.

[Maik Skoddow]

Hi @rahul parshi 

Basically that is not so easy as the sys_properties table a special concept of reading roles:

Without the admin role you need to have all roles which are defined in the "Reading Roles" column.

The better alternative would be to implement a scripted REST API which returns exactly what you need without caring much about roles.

Maik