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

Notifications

Announcements

No record found.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans