Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series.
In the previous post, How to identify the Security Tasks and Security Roles associated with a specific window or report we used the syCurrentResources (SY09400) table to help us identify resources.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series.
Microsoft Dynamics GP version 10.0 introduces a new pessimistic task and role based security model. This model is defined in the following way:
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
For the next couple of weeks, I have decided to focus on Microsoft Dynamics GP application level security and methods for resolving security related issues.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series.
With the change from the optimistic user and class based security model in Microsoft Dynamics GP v9.0 (and v8.0) to the pessimistic role and task base security model in Microsoft Dynamics GP v10.0, a question that is often asked is how can security settings be transferred between a test and live system.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Last week, I posted the article below explaining how you can use the osql.exe command to run a script against all Microsoft Dynamics GP company databases. The method described in this post is best if you have a *.sql script file to execute against each company database:
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This post explains how to use Microsoft Office Word’s Mail Merge functionality to Import Data into Microsoft Dynamics GP. This method can be useful when working with master records or transactions not supported by any of the existing tools such as Integration Manager, eConnect or Web Services.
[Edit] See note about John Arnold’s Replicator Tool at the bottom of this article.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
While administering a Microsoft Dynamics GP system, there are times when a fix or change needs to be applied to each company in the system at the SQL Server level. On a system with a large number of companies this can be a very time consuming task.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Since the release of Microsoft Dynamics GP v10.0 I have seen this question asked many times over on the various newsgroups I monitor (see the Newsgroups Links on the left hand panel of the blog).
The quick answer is…. it has moved into the Data subfolder.
David
— End of Post —
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you have ever spent time analysing a DEXSQL.LOG file you might have seen a reference to a table column called desSPRkmhBBCreh. This post explains what this column is used for and why it has the name it does.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you look at a SQL Server installation of Microsoft Dynamics GP, in the Stored Procedures folder underneath the Dynamics system database or a company database you will find a large number of stored procedures starting with the initials”zDP”. This article explains what the zDP stored procedures do and why they exist.