Back to Home

Menu Assignment

There is a bug in User Menu Assignment. The script needs to run where there needs to be a menu assigned to the user.

Steps

1. Get the menu number by using "Get Menu Number" part from Menu_Assignment.sql script.

use sam_audit
GO
-- GET Menu Number
select * From smart.sam_Master_Menu where manutitle like ''

-- Get User Number
select * From smart.sam_Master_UserList

-- Assign Menu
insert into smart.sam_user_menu
(UserNo, MenuNo, SortOrder, PersonalMenu, AdminNo, DateEntered)
select 8743, 179, 0, 0, 3, GETDATE() UNION
select 8743, 1, 0, 0, 3, GETDATE()

2. Get the user number by using "Get User Number" part.
3. Update the UserNo and MenuNo from "Assign Menu" part.
4. Copy the Insert Into query, save the script as the YYYYMMDD_Menu_Assignment.sql and send out to Bud and Alexandra to be sent to DEVOPS.