Viewing User Security Roles

   Overview   

You can run a query to find a list of all of the security roles given to an employee using the query name "UGA_USERS_ROLES."

   Instructions   

  1. Step 1: Click the drop-down button next to the Employee Self Service menu.
  2. Step 2: Click the UGA Financials link.
  3. Step 3: Click the Query Viewer tile.
  4. Step 4: The Query Viewer page is displayed. Enter appropriate information into the begins with field. Enter " UGA_USERS_ROLES " into the begins with field.
  5. Step 5: Click the Search button.
  6. Step 6: The search results are displayed. Click the HTML  link next to the query UGA_USERS_ROLES.
  7. Step 7: You can search for specific information using the displayed search criteria.
  8. Step 8: The result page is displayed. Click the Excel SpreadSheet link to download the data into an Excel file.
  9. Step 9: Click the Open button.
  10. Step 10: Results are displayed in an Excel sheet. You can filter through the data to view the information that you need by user ID or role name.

In this article, you will learn the steps to run a query to view user data and the associated roles.

1. Step 1

step image

Click the drop-down button next to the Employee Self Service menu.

2. Step 2

step image

Click the UGA Financials link.

3. Step 3

step image

Click the Query Viewer tile.

4. Step 4

step image

The Query Viewer page is displayed. Enter appropriate information into the begins with field.

Enter " UGA_USERS_ROLES " into the begins with field.

5. Step 5

step image

Click the Search button.

6. Step 6

step image

The search results are displayed.

Click the HTML  link next to the query UGA_USERS_ROLES.

7. Step 7

step image

You can search for specific information using the displayed search criteria.

Example shown here: View Results button.

8. Step 8

step image

The result page is displayed. Click the Excel SpreadSheet link to download the data into an Excel file.

Note: Data has been masked to protect employee information.

9. Step 9

step image

Click the Open button.

10. Step 10

step image

Results are displayed in an Excel sheet. You can filter through the data to view the information that you need by user ID or role name.
 
Print Article