Administering GP Security

During my Interactive Discussion at Convergence over GP Security it became clear that I need to post what I do with my customers to help with administering and maintaining their GP security.  This will only focus on GP 10 and later. There are many very well designed reports buildt into the product which are great for documenting, however, they fall short in helping to analyze or maintain your security.  To do security analysis you need something more interactive, something you can slice-n-dice or drill into.  Here are two tools that I use: SQL View (that I can import into Excel) Support Debugging Tool SQL View: There is a great SQL View on MPV Victoria Yudin’s blog site called “ SQL View with Security and SmartList details in GP ”.  Be sure to read her entire post as the SQL View is dependent on the Security Resource Descriptions table being populated, but not by default.  The (counter intuitive) Clear Data method that she describes to populate the table only populates descriptions for Forms and Reports.   The SQL view will return every security setting, but only Forms and Reports will have descriptions.   Since 90% of security analysis and debugging is related to Forms and Report, this view is a great place to start.

Visit site:
Administering GP Security