If you are using Analytical Accounting, you probably know about this pain point – You have to go to “Setup > Company >Analytical Accounting >
User Access” and assign security to new codes before they can be used. Most people have customizations setup by their partners to resolve this.
In GP 2010 - Security access to use a transaction dimension code is granted automatically to the user who created the code during transaction entry. So that’s a great step in the right direction.
CVA Kumar has a couple of posts which should server as good reference – He has a SQL Script to provide access to Transaction Dimension Codes to Users and a Macro to provide access to Transaction Dimension Codes to Users