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 1Click the drop-down button next to the Employee Self Service menu.
  2. Step 2Click the UGA Financials link.
  3. Step 3Click the Query Viewer tile.
  4. Step 4The Query Viewer page is displayed. Enter appropriate information into the begins with field. Enter " UGA_USERS_ROLES " into the begins with field.
  5. Step 5Click the Search button.
  6. Step 6: The search results are displayed. Click the HTML  link next to the query UGA_USERS_ROLES.
  7. Step 7You can search for specific information using the displayed search criteria.
  8. Step 8The result page is displayed. Click the Excel SpreadSheet link to download the data into an Excel file.
  9. Step 9Click the Open button.
  10. Step 10Results 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

Details

Article ID: 149053
Created
Sat 9/24/22 11:02 PM
Modified
Fri 1/5/24 5:06 PM