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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error message when you...
Microsoft Dynamics GP (Archived)

Error message when you try to log on to Microsoft Dynamics GP

(0) ShareShare
ReportReport
Posted on by Community Member
I have created a user class for Payable Management. All users in the class when they login receive the above message, although they click OK and are able to login the facility are not supposed to recieve this message. I have review basic security, and third party security and it all appears to be find. I created a sql log file during the incident and got this results. In the knowledge based article it says to look for SY10000 table and i dont see anything related to it. Can anyone tell me what seems to be the problem? /* Date: 07/13/2009 Time: 14:13:55 stmt(19604808):*/ EXEC DYNAMICS.dbo.zDP_ACTIVITYSS_1 'HIMA San Pablo', 'saotero' /* Date: 07/13/2009 Time: 14:13:55 stmt(19610496):*/ EXEC DYNAMICS.dbo.zDP_SY01402SS_1 'saotero', 15

*This post is locked for comments

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

    Hi,

    What is the error message. Could you post a screen shot?

    Best regards,

  • Community Member Profile Picture
    Community Member on at
    Sorry! that would help "You don't have security privileges to open this window. Contact your system administrator for assistance". it occurs a right at login after you select the company. Even though it appears if you click OK it lets you get trough it. thanks I'll wait for your response!
  • Community Member Profile Picture
    Community Member on at

    Hi,

    This is definately a security issue, but finding it won't be that easy. It could be a shortcut in the users home page that they do not have access to.  First test, can you log in as 'sa' on that machine...without getting the error?

    You are probably best to set a dexsql log to run while you log in, so that you can see exactly what is causing the problem. (If you aren't sure how to do this, let me know). With the log running, try and log in again as the user. When you get to the error message, do not click anything else (ie don't click OK to make the error message go away and continue), just go and locate the sql log which will be co-located with your dex.ini file. Open it and go to the last entry. This will tell you what product the error message relates to, along with whether it is a window or a report, and the window/report ID.

    You can then run a query against the SY09400 using the values above to determine what rsource is cauing the issue. You can then eithre grant security access to this user, or remove the shortcut from their home page. 

    The query would be something like: select * where product ID = ? and windowid = ? and resourceid = ? ... I can't remember the exact field names but a select * against the table will tell you what they are.

    Hope this helps. 

     

  • Community Member Profile Picture
    Community Member on at

    Or, you could click OK to launch GP and then click around on the shortcuts etc. untill you get the error message again.

    (I'm pretty sure the shortcut causing the issue would be displayed even tough it is security denied).

  • Community Member Profile Picture
    Community Member on at
    Thanks for all your help, I went another route. I had all AP users in a class, therefore I created another class for them with new security in case it was corrupted, and it worked!! I no longer have the situation.:)
  • GoFast Profile Picture
    GoFast 200 on at
    Or you can turn on activity tracking for this user and failed attempts to open windows. This will show the window that is tripping the error.
  • Community Member Profile Picture
    Community Member on at

    Go Fast is bang on with that suggestion. Your solution works also! Glad you got it sorted.

  • winthropdc Profile Picture
    winthropdc on at

    For Security Issues in general see

    http://blogs.msdn.com/developingfordynamicsgp/archive/2008/11/10/microsoft-dynamics-gp-application-level-security-series.aspx

    For Security Issues on login see

    http://blogs.msdn.com/developingfordynamicsgp/archive/2008/11/17/how-to-resolve-security-errors-on-login.aspx

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans