SQL View For User–AA Code Access
Hi all In this article, I have posted a script to determine the access to analytical account dimension codes to various users who have access to the company. SELECT DB_NAME() AS COMPANY, A.USERID, C.USERNAME, D.aaTrxDim, D.aaTrxDimDescr, B.aaTrxDimCode, B.aaTrxDimCodeDescr, CASE WHEN ISNULL(E.aaDistribute, 0) = 0 THEN ‘No’ ELSE ‘ Read the rest of this entry
January 15, 2011 · 
veeyeskay · 
One Comment
Tags: Analytical Accounting, Dimension Code, Dimension Code Access, User Access · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 391
SQL Script to provide access to Transaction Dimension Codes to Users
Hi all I had posted an article sometime back titled Macro to provide access to Transaction Dimension Codes to Users where I had provided a SQL script to create a macro code to provide access to all users to all transaction dimension codes setup in the company. I had received a few comments from user [...]
May 11, 2010 · veeyeskay · 10 Comments
Tags: Analytical Accounting, Transaction Dimension Codes, User Access · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 682