Who is Eligible?
Active Faculty or Staff
Requesting an Argos ADO Connection
Instructions for DEPARTMENTS / BUSINESS AREAS
User -
- Complete and review the "Argos - Connection ID Request" form
- Discuss the "model process" with your Group Folder Owner
- Document either the Model User(s) or Roles List
- Get Supervisor approval
- Get Group Owner approval
- Submit and Route to UTS at uts@oakland.edu
Please provide the following information within the Connection ID Request Form:
- Server Name:
- Type of Database: (Oracle, PostgreSQL, MySQL, etc)
- Database Name:
- UserID: <you must create on your database>
- Password: (please provide via phone call/message)
UTS - Argos Admin -
- Verify Supervisor and Group Owner approvals
- Compile the list of Roles
- Identify the applicable Banner Data Stewards based on the List of Roles
- List the Roles in the Argos Footprints Ticket by Banner Data Steward
- CC all the appropriate Data Stewards for approval
- Verify all appropriate Data Stewards have approved
- Create or Modify the Argos Group ID; grant the List of Roles
- Update Argos Ticket in UTS Footprints
To Get a List of Roles, Grant Statements and Request to Data Stewards
Instructions for UTS DBA Team
List of Roles
SELECT UPPER(:argos_connection) "Argos Connection ID"
, UPPER(:argos_model_user) "User Model"
, granted_role "Roles to be Granted"
FROM sys.dba_role_privs
WHERE grantee = UPPER(:argos_model_user)
AND granted_role NOT LIKE 'BAN_DEFAULT%'
AND granted_role NOT LIKE 'USR%'
AND granted_role NOT LIKE 'BAN_UTS%'
AND granted_role NOT LIKE 'BAN_SECURITY%'
ORDER BY granted_role
;
Grant Statements
SELECT 'GRANT "' || granted_role || '" TO "' || UPPER(:argos_connection) || '";' AS sql_argos_grants
FROM sys.dba_role_privs
WHERE grantee = UPPER(:argos_model_user)
AND granted_role NOT LIKE 'BAN_DEFAULT%'
AND granted_role NOT LIKE 'USR%'
AND granted_role NOT LIKE 'BAN_UTS%'
AND granted_role NOT LIKE 'BAN_SECURITY%'
ORDER BY granted_role
;
Footprints Request to Data Stewards
In the Footprints Ticket, insert the below BOLDED comment and CC the appropriate Data Stewards.
The following access (Roles) has been requested for the Argos Reporting ID (ARGOS_XXXXXXXX). This Banner Oracle ID will be used within Argos Reporting by the XXXXXXXX area.
Data Steward approval is needed by each area listed below. Please reply to this request with either "Approve" or "Deny".
SELECT UPPER(:argos_connection) "Argo Connection ID", UPPER(:argos_model_user) "User Model", x.name "Banner Form", x.ctr_name "Banner Role", x.steward_name "Data Stewards"
FROM (
SELECT f.fileno
, z.code
, f.name
, z.steward_name
, b.ctr_description
, b.ctr_name
FROM esign.webfile f,
(
SELECT s.code, LISTAGG(s.steward_name, ', ') WITHIN GROUP (ORDER BY s.steward_name DESC) steward_name
FROM esign.data_stewards s
GROUP BY s.code
) z,
esign.banner_forms b
WHERE z.code = SUBSTR(f.fieldnames, INSTR(f.fieldnames,'DataSteward')+12, (INSTR(f.fieldnames, ',', INSTR(f.fieldnames,'DataSteward')) - (INSTR(f.fieldnames,'DataSteward')+12)))
AND f.fileno = b.fileno
AND f.fieldnames LIKE '%DataSteward%'
AND b.ctr_name IN (
SELECT granted_role
FROM sys.dba_role_privs
WHERE grantee = UPPER(:argos_model_user)
AND granted_role NOT LIKE 'BAN_DEFAULT%'
AND granted_role NOT LIKE 'USR%'
AND granted_role NOT LIKE 'BAN_UTS%'
AND granted_role NOT LIKE 'BAN_SECURITY%'
)
ORDER BY z.code, z.steward_name, b.ctr_name
) x
ORDER BY x.name, x.ctr_name;
Additional Support
- OU Technology Center
- 44 Oakland Center
- Rochester, MI 48309-4479
- (248) 370-4357
- Office Hours: M-F 8:00am - 5:00pm