User Roles
View Current User Roles
Use query ASD_USER_ROLES to determine what roles an employee has.
Research Necessary User Roles
Per Tracey Bell, here is how you can determine what user role accesses a page:
To determine the user, role, and permission list for a page you must first navigate off of the search page. In this case, remove the userid and enter. You will get a list of all users with journals locked:
When on a page enter & hold Shift>Ctrl>J keys – here you find the page name
Go to Query Manager and search by OKCSEC, there are numerous queries to choose from. You are looking for the role, so select OKCSEC_USER_ROLE. I typically use the last query in the list as it also lists the permission list & user and saves time.
When you run the query you are prompted for the name of the page. Enter page and select View Results
Use query ASD_USER_ROLES to determine what roles an employee has.
Research Necessary User Roles
Per Tracey Bell, here is how you can determine what user role accesses a page:
To determine the user, role, and permission list for a page you must first navigate off of the search page. In this case, remove the userid and enter. You will get a list of all users with journals locked:
When on a page enter & hold Shift>Ctrl>J keys – here you find the page name
Go to Query Manager and search by OKCSEC, there are numerous queries to choose from. You are looking for the role, so select OKCSEC_USER_ROLE. I typically use the last query in the list as it also lists the permission list & user and saves time.
When you run the query you are prompted for the name of the page. Enter page and select View Results