web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Solomon User

(0) ShareShare
ReportReport
Posted on by 30

When user trying to access information into Solomon following messge shows: No Privacy Permissions record exists for you. All access will be denied. Please help

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi Intrepid,

    You might want to try having everyone log out of SL and then go into Database Maintenance and run the Synchronize All Ownership and Security. This should correct the issue that the user is having. If the user still has permission errors when trying to retrieve information, you may want to run a SQL trace. I have copied the link for downloading the templates that you will need to use. Import the template (that matches your version of SQL Server) to the SQL Profiler and start a trace. Have the user replicate the permissions error then stop the trace. You will then need to look through the trace to find out what permissions are needed. You should also see the error that the user was getting (or something similar).

     

    967955 How to use SQL Profiler in SQL Server 2008 and SQL Server 2008 R2 to trace database events in Microsoft Dynamics SL https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;967955 

    Also has a link for the template for SQL Server 2005. If you are running SQL Server 2012, we currently do not have a KB article with the template attached.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans