Assign Different Ownership to Queries or Make Them Public

Administrator access allows the PS Query user to rename queries, change ownership and move them from private to public in the Campus Solutions database.  This may only work for you in a specific CS database as your access levels in each of the CS databases may differ.

REPORT-326 - Document Query Administrator Role Closed

Navigate to the desired database and select People Tools > Utilities > Administration > Query Administration

Search by Query name or Owner ID (EMPLID).  In this case we searched by ID to get the private queries of this owner.

Click the select button next to the query or queries you would like to reassign.

In the Owner ID box, enter the EMPLID of the person you want to transfer the query to, or leave blank to make it public. If making public, make sure to write down the name of the query so that you can find it again if you need it.  You will no longer be able to search by owner!

Attachments:

QueryAdminScreen.JPG (image/jpeg)
QueryAdminSearchResults.JPG (image/jpeg)
ChangeOwner.JPG (image/jpeg)
SelectQuery.JPG (image/jpeg)