75,730
What is the security table that controls which menu options users see in GP? I have 1 user that is setup just like a bunch of other users. For this user there are several menu options missing. I want to check what is in the table before I go and spend time creating a new user and assigning rights.
*This post is locked for comments
This is for a third party product. I have asked them for a solution. It is possible they have not create a role/task combination for this screen.
it sounds like there's a security task added to someone's role that's "out of the norm" for role assignments. What menu are they trying to access? I can take a look at the view and determine which security task is required and then you can see if it's applied.
This is a T/S environment. If I grant her PowerUser status she sees the menu item so I know it is not a forms dictionary issue. As a matter of fact it is a menu issue. The menu item to get to the screen is not there. As a PowerUser she sees the menu item and can get to the window.
What I am trying to determine is why this user does not see the same menu items as the other users who are assigned the same roles. Is there a table that contains the user ID's and the menu items they are allowed to see? If I could compare this one errant user to a good user I could adjust the table.
I think it depends on what you're looking for, the tables, descriptions and series are kept in different tables.
you'll need to reference SY10500, SY01400, SY10600, SY01500, SY10700, SY09400.
Here's a view I created in our system a year ago.
CREATE VIEW [dbo].[GP_Permission]
AS
SELECT
SY10500.USERID,
SY01400.USERNAME,
SY01500.CMPNYNAM,
SY10500.SECURITYROLEID,
SY10600.SECURITYTASKID,
SY09000.SECURITYTASKNAME,
SY09000.SECURITYTASKDESC,
SY09400.PRODNAME,
SY09400.TYPESTR,
SY09400.Series_Name,
SY09400.DSPLNAME
FROM SY10500
left outer join SY01500 on SY01500.CMPANYID = SY10500.CMPANYID
left join SY10600 on SY10600.SECURITYROLEID = SY10500.SECURITYROLEID
left join SY01400 on SY01400.USERID = SY10500.USERID
left join SY09000 on SY09000.SECURITYTASKID = SY10600.SECURITYTASKID
left join SY10700 on SY10700.SECURITYTASKID = SY10600.SECURITYTASKID
left join SY09400 on (convert(VARCHAR(4),SY10700.DICTID)
+ convert(VARCHAR(9),SY10700.SECURITYID)
+ convert(VARCHAR(4),SY10700.SECRESTYPE)) = (convert(VARCHAR(4),SY09400.DICTID)
+ convert(VARCHAR(9),SY09400.SECURITYID)
+ convert(VARCHAR(4),SY09400.SECRESTYPE))
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (