What?Axapta.com Forums: audit reports

Message

   We do not have enough licenses to run the 'user permissions*' report.  We can only run the other permission reports for 1 user or group at a time.  This is too time consuming with 200+ users. 
I have created a query using the USERGROUPLIST and USERINFO tables to show who has specific groups.
 I cannot find the tables that show the permissions for each group.  Can I create a report to show this detail?  What tables do I need to use?
Thanks,

Edited by kannan - 28 Jul 2010 at 10:53am

Author	Message
kannan Newbie Joined: 28 Jul 2010 Online Status: Offline Posts: 3	Topic: audit reports Posted: 28 Jul 2010 at 10:52am
	We do not have enough licenses to run the 'user permissions*' report. We can only run the other permission reports for 1 user or group at a time. This is too time consuming with 200+ users. I have created a query using the USERGROUPLIST and USERINFO tables to show who has specific groups. I cannot find the tables that show the permissions for each group. Can I create a report to show this detail? What tables do I need to use? Thanks, Edited by kannan - 28 Jul 2010 at 10:53am
	IP Logged

admin Admin Group Joined: 29 Dec 2006 Location: United States Online Status: Offline Posts: 127	Posted: 28 Jul 2010 at 10:54am
	The table you are looking for is a system table called: AccessRightsList. This will give you detailed information about permissions for each group.
	IP Logged

kannan Newbie Joined: 28 Jul 2010 Online Status: Offline Posts: 3	Posted: 28 Jul 2010 at 10:54am
	Why are some fields blank in the ELEMENTNAME field? I can't get this table to to tie against the user group permissions table. Is there something I am not seeing?
	IP Logged

admin Admin Group Joined: 29 Dec 2006 Location: United States Online Status: Offline Posts: 127	Posted: 28 Jul 2010 at 11:00am
	The elementname will be missing on permissions set on tables. Look at the "ID" field whenever you see a blank elementname. The ID will correspond to the table ID. You should be able to link USERGROUPLIST to ACCESSRIGHTSLIST on groupID's. The accessType field in table ACCESSRIGHTSLIST will give you what permission each group have. See these links: http://msdn.microsoft.com/en-us/library/aa875695.aspx http://msdn.microsoft.com/en-us/library/aa849536.aspx Hope this helps!
	IP Logged

REPORTING SERVICES
What?Axapta.com Forums : CATEGORIES : REPORTING SERVICES