{"id":24216,"date":"2021-12-28T15:09:46","date_gmt":"2021-12-28T15:09:46","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=24216"},"modified":"2021-12-28T15:09:49","modified_gmt":"2021-12-28T15:09:49","slug":"row-level-permission-setup-at-user-level-in-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2021\/12\/28\/row-level-permission-setup-at-user-level-in-x3\/","title":{"rendered":"Row Level Permission Setup at User Level in X3"},"content":{"rendered":"\n<p>In X3, we can provide restricted data access to external BPs or we can have restricted filtering on data which can be viewed by only particular Bps. Row level permission is nothing but filtering the data in a selective manner as a function or user concerned to be presented to the users when connected via other external connections. Using row level permission, we can allow users to access certain data defined in user setup.<\/p>\n\n\n\n<p>Principles of functioning:<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>There are certain role codes provided in selection list representing as an object.<\/li><li>A role is associated with a list of functions for which a filter is applied on a given field.<\/li><li>You can define one or more roles for a particular user.<\/li><\/ol>\n\n\n\n<p>Once this setup is done and the roles are defined for users:<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>A filter is created in the object (quick select list, selection windows) on the code(s) defined in the user record.<\/li><li>A control is made during the creation of the filtered fields.<\/li><li>A filter can be carried out in the requester.<\/li><\/ol>\n\n\n\n<p>For example, by default user A can access all sites existing in X3 or can create new sites, too. As given in below screenshot, you can see currently user A can see\/access all the sites exist in X3.<\/p>\n\n\n\n\n\n<p>But if you want that user A should access only particular sites or you want to allow user A to create sites with certain names then you can setup the same as per below screenshot. Follow below steps for the same.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Navigate to: Setup &gt; Users &gt; Users &gt; Select user A<\/li><li>Here, in permission code you have to enter object code as \u2018FCY\u2019 (site) to which you want to restrict access. In \u2018key\u2019 column you can setup the values for respective objects as here values defined are \u2018AO011\u2019 and \u2018AO012\u2019 which means user A can access\/see only these two sites.<\/li><\/ol>\n\n\n\n\n\n<p>In below screenshot, you can see only sites \u2018AO011\u2019 and \u2018AO012\u2019 are accessible to user A.<\/p>\n\n\n\n\n\n<p>Also, currently there is no existing site \u2018YSITE\u2019 which is defined below. That means user A cannot create any site except \u2018YSITE\u2019 in future. If he attempts to create any site other than this, he will get an error. For example, if user A attempts to create site \u2018ZSITE\u2019 then he will get an error as shown in below screenshot.<\/p>\n\n\n\n\n\n<p>Thus, you can allow restricted data access associated with objects to the users.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>About Us<\/strong><\/h2>\n\n\n\n<p>Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n<p id=\"block-28013e99-0882-44c6-b705-7b16c85053b2\">Greytrix&nbsp;has some unique integration solutions developed for&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-crm\/\">Sage CRM<\/a>&nbsp;with Sage ERPs&nbsp;namely&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/\">Sage X3<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-intacct\/\">Sage Intacct<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-100-erp\/\">Sage 100<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-500-erp\/\">Sage 500<\/a>,&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-300-erp\/\">Sage 300<\/a>. We also offer best-in-class&nbsp;Sage ERP&nbsp;and&nbsp;Sage CRM&nbsp;customization and development services&nbsp;to&nbsp;Business&nbsp;Partners,&nbsp;End&nbsp;Users, and Sage PSG worldwide. Greytrix&nbsp;helps in&nbsp;the migration of Sage CRM from&nbsp;Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes&nbsp;addons like&nbsp;&nbsp;Greytrix Business Manager,&nbsp;Sage CRM Project Manager,&nbsp;Sage CRM Resource Planner,&nbsp;Sage CRM Contract Manager,&nbsp;Sage CRM Event Manager,&nbsp;Sage CRM Budget Planner,&nbsp;Gmail Integration,&nbsp;Sage CRM Mobile Service Signature,&nbsp;Sage CRM CTI Framework.<\/p>\n\n\n\n<p id=\"block-4bc42a09-fb13-4598-8137-ce5f7b91ce28\">Greytrix is a recognized&nbsp;Sage Champion Partner&nbsp;for GUMU&#x2122; Sage X3 \u2013 Sage CRM integration listed on&nbsp;<a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Marketplace<\/a>&nbsp;and Sage CRM \u2013 Sage Intacct integration listed on&nbsp;<a href=\"https:\/\/marketplace.intacct.com\/MPListing?lid=a2D0H000007kiHyUAI\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Intacct Marketplace<\/a>. The&nbsp;<a href=\"https:\/\/www.greytrix.com\/gumu\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Cloud framework<\/a>&nbsp;by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n<p id=\"block-76376301-1c3e-4250-8a09-727595a606f0\">For more information on our integration solutions, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In X3, we can provide restricted data access to external BPs or we can have restricted filtering on data which can be viewed by only particular Bps. Row level permission is nothing but filtering the data in a selective manner as a function or user concerned to be presented to the users when connected via\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2021\/12\/28\/row-level-permission-setup-at-user-level-in-x3\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,5,8],"tags":[3500,1699,3501],"class_list":["post-24216","post","type-post","status-publish","format-standard","hentry","category-faq","category-features","category-sage-erp-x3","tag-role-management","tag-roles","tag-row-level-permission"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/24216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=24216"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/24216\/revisions"}],"predecessor-version":[{"id":24231,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/24216\/revisions\/24231"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=24216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=24216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=24216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}