{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":40219,"path":"platform-administration/user-administration/c_ReadOnlyRole.md","title":"Read-only role","bundle":null,"doc_type":null,"release":"australia","body":"\n# Read-only role\n\nThe read-only role \\(snc\\_read\\_only\\) restricts a user or a group of users to read-only access on the tables to which the user already has access.\n\nThis role is designed to complement other roles a user possesses. Its purpose is to restrict actions like the insert, update, or delete operations on the tables accessible through their existing roles.\n\nAfter you assign this role to a user, they can no longer create, update, or delete records on ANY tables.\n\n**Note:** Assign this role only to users. Don’t assign this role to other resources in the system, including applications, access control levels \\(ACLs\\), and so on.\n\nThe **snc\\_read\\_only** role can be assigned to any user to limit access to data without having to create ACLs for system tables, custom tables, and fields. This practice is useful for performing internal or external audits without enabling a user to have insert or update access to data.\n\nUsers with the **snc\\_read\\_only** role have the following restrictions regardless of other roles and privileges that they have.\n\n-   Can't insert, update, or delete records from the UI or when using the GlideRecord API.\n-   Can't activate or upgrade plugins.\n-   Can't directly run SQL.\n-   Can't upload XML files.\n-   Can only run background scripts when on an instance in the public sandbox environment.\n\n**Note:** These role restrictions are in place even if impersonating another user with write access such as an admin.\n\n## Exempt tables from the read-only restriction\n\nThree system properties control which tables users with the **snc\\_read\\_only** role can still create, update, or delete records on. These properties are not created on instances by default. To use them, manually add each property to the System Properties \\[sys\\_properties\\] table and set the value to a comma-separated list of table names. See [Add a system property](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/t_AddAPropertyUsingSysPropsList.md).\n\n|Property|Description|\n|--------|-----------|\n|**glide.security.snc\\_read\\_only\\_role.tables.exempt\\_create**|Comma-separated list of tables on which users with the **snc\\_read\\_only** role can create records.|\n|**glide.security.snc\\_read\\_only\\_role.tables.exempt\\_write**|Comma-separated list of tables on which users with the **snc\\_read\\_only** role can update records.|\n|**glide.security.snc\\_read\\_only\\_role.tables.exempt\\_delete**|Comma-separated list of tables on which users with the **snc\\_read\\_only** role can delete records.|\n\n**Parent Topic:**[Base system roles](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/user-administration/r_BaseSystemRoles.md)\n\n## Activate the read-only role\n\nIf it isn’t already active, an administrator can activate the Read-Only User Role \\(com.snc.read\\_only.role\\) plugin.\n\n### Before you begin\n\nRole required: admin\n\n### Procedure\n\n1.  Navigate to **All** &gt; **System Applications** &gt; **All Available Applications** &gt; **All**.\n\n2.  Find the Read-Only User Role \\(com.snc.read\\_only.role\\) plugin using the filter criteria and search bar.\n\n    You can search for the plugin by its name or ID. If you cannot find a plugin, you might have to request it from ServiceNow personnel.\n\n3.  Select **Install** to start the installation process.\n\n    **Note:** When domain separation and delegated admin are enabled in an instance, the administrative user must be in the **global** domain. Otherwise, the following error appears: `Application installation is unavailable because another operation is running: Plugin Activation for <plugin name>.`\n\n    You will see a message after installation is completed. For information about the components installed with a plugin, see [Find components installed with an application](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/find-components.md).\n\n\n## Read-only role properties\n\nThese system properties control the snc\\_read\\_only role. The following default values are used for the properties.\n\n<table id=\"simpletable_tqr_1hx_4zb\"><thead><tr><th>\n\nName\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\n**glide.security.snc\\_read\\_only\\_role.tables.exempt\\_create**\n\n</td><td>\n\nSpecifies which tables are exempt from the read-only role enforcement and enable the creation of new records.\n\n -   Type: string\n-   Default value: sys\\_user\\_session, sysevent, syslog, syslog\\_transaction, sys\\_user\\_preference, sys\\_ui\\_list, sys\\_ui\\_list\\_element, sys\\_db\\_cache, user\\_multifactor\\_auth\n-   Location: System Properties \\[sys\\_properties\\] table\n\n</td></tr><tr><td>\n\n**glide.security.snc\\_read\\_only\\_role.tables.exempt\\_write**\n\n</td><td>\n\nSpecifies which tables are exempt from the read-only role enforcement and enable the updating of existing records.\n\n -   Type: string\n-   Default value: sys\\_user\\_session, sysevent, syslog, syslog\\_transaction, sys\\_user\\_preference, sys\\_ui\\_list, sys\\_ui\\_list\\_element, sys\\_db\\_cache, user\\_multifactor\\_auth\n-   Location: System Properties \\[sys\\_properties\\] table\n\n</td></tr><tr><td>\n\n**glide.security.snc\\_read\\_only\\_role.tables.exempt\\_delete**\n\n</td><td>\n\nSpecifies which tables are exempt from the read-only role enforcement and enable the deletion of existing records.\n\n -   Type: string\n-   Default value: sys\\_user\\_preference, sys\\_ui\\_list, sys\\_ui\\_list\\_element, sys\\_db\\_cache, user\\_multifactor\\_auth\n-   Location: System Properties \\[sys\\_properties\\] table\n\n</td></tr></tbody>\n</table>After you configure these properties, assign the read-only role as needed. When you log in, you’re restricted from creating, updating, or deleting records on ANY tables unless you modified these properties.\n\n**Note:** Test the read-only role by assigning it to a user and then impersonating that user.\n\n"}}