Find SY_Users Records with Specific Access Right

04/29/2024 9:49 am EDT

Description of Issue:

How can we find the user groups and users who have access to a specific access right in SedonaOffice?

Resolution:

The script below can be used to determine the Users and User Groups that have access to a specific access right in SedonaOffice.

A screenshot of a computer
Description automatically generated

DECLARE @Menu_Option AS VARCHAR(100)  

--- Enter all or part of the Application Access Description.  
--- Leave the % at the beginning and end of the description.   

SET @Menu_Option = '%Re-Opened Periods%'    

Select g.Description as User_Group,m.Description as Access_Option, u.*  
From SY_User_Group_Acc_Detail d 
Inner Join SY_User_Group g on g.User_Group_Id =d.User_Group_Id 
Inner Join SS_Menu m on m.Menu_Id =d.Menu_Id 
Inner Join SY_User_Group_Join j on j.User_Group_Id=g.User_Group_Id 
Inner Join SY_Users u on u.User_Id = j.User_Id 
Where m.Description like @Menu_Option 
and u.Inactive<>'Y' 
Order by User_Group

Was this article helpful?