As we already know through Organization wide default, record access to different users in system can be controlled. Apart from OWD, user can get record access through role, being a part of public group with which record is shared, territories etc. In order to control access of records, Salesforce maintain record sharing data and recalculate the sharing when any changes happen to role, territory, public group etc. For end user, changing user's role is simple operation but at the back end, Salesforce has to perform all record sharing recalculation based on user's new role.
Lets discuss all this in details. First we will start with Database Architecture. Salesforce maintains 3 types of tables as mentioned below:
SOQL INJECTION IN SOQL
CUSTOM METADATA AND CUSTOM SETTINGS IMPLEMENTATION TRICKS
SMART TABLE USING ANGULARJS IN VISUALFORCE PAGE
REST API TUTORIAL FOR SALESFORCE
VISUALFORCE COMPONENT FOR RECORD STATUS BAR
DYNAMICALLY CREATING AND DESTROYING LIGHTNING COMPONENTS
RAISING AND HANDLING CUSTOM EVENTS IN sALESFORCE lIGHTNING
WHY TO USE DESIGN RESOURCE AND HOW TO ADD DYNAMIC OPTION TO DATASOURCE
PASSING INNER WRAPPER CLASS TO LIGHTNING COMPONENT
LIGHTNING COMPONENT FOR RECORDTYPE SELECTION FOR ANY SOBJECT
Lets discuss all this in details. First we will start with Database Architecture. Salesforce maintains 3 types of tables as mentioned below:
- Object Record Table
These are the tables which stores records of specific object and indicate which user or queue owns each record.
- Object Sharing Table
If OWD of any object is public read only or private, the Salesforce create share table for that object.This table store information about record access for all users which is shared by explicit grant (shared with user or group) or implicit grant (built in sharing like access to child opportunity, cases if you have access to account record).
- Group Maintenance Tables
This table stores list of users or groups that belong to each group indicating group membership. Suppose a record is shared with group, then Salesforce check group maintenance table to identify which all users inherit access to that record (either through role hierarchy, group membership or through territories).
So when Salesforce has to find out that if user has access to record, then it perform join between three tables to identify record access for user. If user is owner of record, then it will display that record. If not it will check object sharing table and group maintenance table to find users access to record.
Salesforce Role hierarchy, public groups and territories are closely connected with sharing rules and security features. Suppose an user owns more than 10,000 records and now admin just changed this role. Now salesforce need to remove access to all these records for all user which are having higher role than user's previous role and need to provide access to all user's in higher role than new user's new role. So Salesforce has to recalculate the record access and sometimes it may take more time.
In order to handle these scenarios, Salesforce provide few tools which can be used to avoid these issues caused by user realignment either through roles, territory or public groups:
- Parallel Sharing Rule Calculation
Whenever admin changes user's role or change group membership or create, edit or delete sharing rules, then recalculation for record access happens synchronously. So when any of these changes affects access right to large number of records, the recalculation job take longer time. If any Salesforce perform any activity at this time like patch release or upgrade, then recalculation jobs get killed. In this scenrio, consider parallel Sharing Rule calculation. This will split the job in multiple threads which will run asynchronously and if Salesforce perform any activity, these jobs will resume after salesforce activity.
Contact Salesforce in order to enable this feature.
- Deferred Sharing Maintenance
Suppose you have rebuild the role hierarchy and group membership, the sharing recalculation may take significant time. In this kind of scenarios, you can enable deferred sharing which will allow admins to switch off of sharing recalculation and perform all role and group membership changes and then switch on sharing calculation. After switching on sharing calculation, admin has to start recalculation of all sharing rules for accurate user access rights.
Remenber deferred sharing doesnot stop sharing recalculation due to implicit sharing.
Contact Salesforce in order to enable this feature.
- Granular locking
Whenever any change is performed to roles or group, Salesforce locks entire Group membership table to protect data integrity. This will make impossible to perform group membership changes. Consider a scenario in which your users are facing frequent record locking error and restrict their ability to manage manual and automatic update at same time or degrade the group maintenance updates, then enable Granular Locking feature.
If Granular locking feature is enabled then system will lock portion of records instead of locking entire Group maintenance table. This allow multiple update simultaneously if there is no hierarchical or other relationship between the roles and groups involved in the update.
You need to contact Salesforce to enable Granular locking feature.
More Blogs>>:
DYNAMIC APEX IN SALESFORCE
SOQL INJECTION IN SOQL
CUSTOM METADATA AND CUSTOM SETTINGS IMPLEMENTATION TRICKS
SMART TABLE USING ANGULARJS IN VISUALFORCE PAGE
REST API TUTORIAL FOR SALESFORCE
VISUALFORCE COMPONENT FOR RECORD STATUS BAR
DYNAMICALLY CREATING AND DESTROYING LIGHTNING COMPONENTS
RAISING AND HANDLING CUSTOM EVENTS IN sALESFORCE lIGHTNING
WHY TO USE DESIGN RESOURCE AND HOW TO ADD DYNAMIC OPTION TO DATASOURCE
PASSING INNER WRAPPER CLASS TO LIGHTNING COMPONENT
LIGHTNING COMPONENT FOR RECORDTYPE SELECTION FOR ANY SOBJECT
Hai Author Good Information that i found here,do not stop sharing and Please keep updating us..... Thanks
ReplyDeleteGreat Article
DeleteCyber Security Projects for CSE Students
JavaScript Training in Chennai
Project Centers in Chennai
JavaScript Training in Chennai
https://globalwebsolution.net/ was founded in 2013 by Junaid Ali It was in college where he discovered a new and better version of the contemporary brand design agency. One where a global network of independent experts share values and a passion to co-create a world where people connect deeper with the things they love. The discovery was not just a broader vision for brand design, communication.
ReplyDeleteThe blog is clear demonstration of the fact that, you can’t compromise with the quality.
ReplyDeleteresumeyard.com
This comment has been removed by the author.
ReplyDeletethank your valuable content.we are very thankful to you.one of the recommended blog.which is very useful to new learners and professionals.content is very useful for hadoop learners
ReplyDeleteBest Spring Classroom Training Institute
Best Devops Classroom Training Institute
Best Corejava Classroom Training Institute
Best Advanced Classroom Training Institute
Best Hadoop Training Institute
Best PHP Training Institute
A bewildering web journal I visit this blog, it's unfathomably heavenly. Oddly, in this present blog's substance made purpose of actuality and reasonable. The substance of data is informative
ReplyDeleteOracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
ReplyDeleteOracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
In the event that your organization is diminished to a second or third page section you'll lose a lot of traffic, as individuals normally select connections from the main page. Webdesign
ReplyDeleteAn overwhelming web journal I visit this blog, it's unfathomably amazing. Unusually, in this present blog's substance made inspiration driving truth and reasonable. The substance of data is enlightening
ReplyDeleteOracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Excellent Blog. Thank you so much for sharing.
ReplyDeletehadoop interview questions
Hadoop interview questions for experienced
Hadoop interview questions for freshers
top 100 hadoop interview questions
frequently asked hadoop interview questions
hadoop interview questions and answers for freshers
hadoop interview questions and answers pdf
hadoop interview questions and answers
hadoop interview questions and answers for experienced
hadoop interview questions and answers for testers
hadoop interview questions and answers pdf download
hadoop interview questions pdf
A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
ReplyDeleteOracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Thanks for sharing valuable information.
ReplyDeleteDigital Marketing training Course in Chennai
digital marketing training institute in Chennai
digital marketing training in Chennai
digital marketing course in Chennai
digital marketing course training in omr
digital marketing certification in omr
digital marketing course training in velachery
digital marketing training center in Chennai
digital marketing courses with placement in Chennai
digital marketing certification in Chennai
digital marketing institute in Chennai
digital marketing certification course in Chennai
digital marketing course training in Chennai
Digital Marketing course in Chennai with placement
digital marketing courses in Chennai
Pretty amazing work on the author's part and This blog is a five star work.www.canvasprints.com
ReplyDeleteThank you for sharing this useful article with us. This blog is a very helpful to me in future. Keep sharing informative articles with us.
ReplyDeletehttps://www.ahmedabadcomputereducation.com/course/php-training-course/
Thank you for sharing this useful article with us. This blog is a very helpful to me in future. Keep sharing informative articles with us.
ReplyDeletehttps://www.ahmedabadcomputereducation.com/course/laravel-training-course/
Awesome blog. It was very informative. I would like to appreciate you. Keep updated like this!
ReplyDeleteSaleforce Training in Gurgaon
Saleforce Developer Training in Gurgaon
Salesforce lightning training in Gurgaon
Salesforce Einstein training in Gurgaon
Salesforce integration training in Gurgaon
Thanks for giving great kind of information
ReplyDeletesalesforce online training in india
salesforce training
Thank you for sharing this useful article. This blog is a very helpful to me. Keep sharing informative articles with us.
ReplyDeletehttps://www.france-collectivites.fr/
Awesome blog for knowledge. Thank you for sharing this useful article. This blog is a very helpful to me. Keep sharing this type informative articles with us.
ReplyDeletehttps://www.france-collectivites.fr/
Great sources for knowledge. Thank you for sharing this helpful article. It is very useful for me.
ReplyDeletehttps://www.ahmedabadcomputereducation.com/course/laravel-training-course/
Thank you for sharing this useful article with us. This blog is a very helpful to me. Keep sharing informative articles with us.
ReplyDeletehttps://www.sdsfin.in/services/project-finance-consultants-in-ahmedabad/
Awesome content for reading as well as knowledge. Thank you for sharing this informative article with us.
ReplyDeletehttps://www.sdsfin.in/about-us/
That would seem wholly great. Every one compact info are designed coupled with number of track record comprehension. Everyone loves the following a lot. mobile app development company
ReplyDeleteSeo company in Varanasi, India : Best SEO Companies in Varanasi, India: Hire Kashi Digital Agency, best SEO Agency in varanasi, india, who Can Boost Your SEO Ranking, guaranteed SEO Services; Free SEO Analysis.
ReplyDeleteBest Website Designing company in Varanasi, India : Web Design Companies in varanasi We design amazing website designing, development and maintenance services running from start-ups to the huge players
Wordpress Development Company Varanasi, India : Wordpress development Company In varanasi, india: Kashi Digital Agency is one of the Best wordpress developer companies in varanasi, india. Ranked among the Top website designing agencies in varanasi, india. wordpress website designing Company.
E-commerce Website designing company varanasi, India : Ecommerce website designing company in Varanasi, India: Kashi Digital Agency is one of the Best Shopping Ecommerce website designing agency in Varanasi, India, which provides you the right services.
It's a very informative blog and I am exactly looking for this type of blog. Thank you for sharing this beautiful blog.
ReplyDeletehttps://superurecoat.com/titanium-iso-propoxide/
Thank you for sharing valuable information with us. Exactly, I am looking for this types of blog.
ReplyDeleteLoan Against Property
Loan Against Property in Vadodara
Loan Against Property in Ahmedabad
Loan Against Property Companies
Loan Against Property Interest Rate
Thank You for sharing this informative article.
ReplyDeletehttps://web30india.com/
I am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up
ReplyDeleteExcellent Blog. Thank You for Sharing!
ReplyDeleteBest Mobile App Development Company in UK | Mobile App Development Services
ReplyDeleteI am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up
Devops Training in Hyderabad
Hadoop Training in Hyderabad
Python Training in Hyderabad
Tableau Training in Hyderabad
Selenium Training in Hyderabad
Very Nice Blog…Thanks for sharing this information with us. Here am sharing some information about training institute.
ReplyDeletetableau training in hyderabad
I cannot thank you enough for the blog.Thanks Again. Keep writing.
ReplyDeleteservicenow training
servicenow online training
If you are able to rely on personal referrals or word of mouth, this is likely to offer the most efficient way of locating a reliable web design service. But, if you don't have this opportunity you can use the Internet to search for the companies that seemed to be offering the type of design service you require. You might wish to look at the locally based companies or outsource overseas for getting the right service. If you are able to find positive comments next to a company's name when conducting the research this is likely to be a good indication that you have located a reliable Web Design Company Toronto
ReplyDeleteThis can be a very informative and helpful post, very genuine and practical advice.Goldcoders hyip template
ReplyDeleteNice to see your content. hire angularjs developer to create user-friendly apps to impress your target audience and achieve quick sales
ReplyDeletehire dedicated laravel developer
hire react native developer
hire react native app developer
I am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up
ReplyDeleteDevops Training in Hyderabad
Hadoop Training in Hyderabad
Python Training in Hyderabad
Tableau Training in Hyderabad
Selenium Training in Hyderabad
informatica Training in Hyderabad
informatica Training in Hyderabad
kyrie 7 shoes
ReplyDeletemoncler
curry 8 shoes
supreme outlet
jordan 12
jordan shoes
curry 6 shoes
moncler
off white outlet
cheap jordans
Android Mobile App Development in Ahmedabad
ReplyDeleteWeb 3.0 India is the most trusted Web3 Blockchain Development and NFT Development Company in USA. We also provides ICO, STO development for cryptocurrency.
https://web30india.com/
This article is very attractive. Those who need this information, it's very informative and understandable for those all. Thanks for this information. Hire React Native app Developer
ReplyDeleteThank you for this amazing article. It will very helpful for us.
ReplyDeleteBest Website Design Company in UK
Mobile App Design in UK
Software Development Company in UK
Hire Blockchain Developers
Build Smart Mobile App
Best Mobile App Development company in Uk
Thank you for this knowledgeable article.
ReplyDeleteBlockchain Development Company in Ahmedabad
Web3 Development Company
Mobile Application Development