Differences between revisions 1 and 2
Revision 1 as of 2019-11-15 14:03:19
Size: 4196
Editor: cox
Comment:
Revision 2 as of 2019-11-15 14:06:14
Size: 4856
Editor: cox
Comment:
Deletions are marked like this. Additions are marked like this.
Line 4: Line 4:
= Argos Connectin ID = = Argos File Operations to Shares =
Line 7: Line 7:
== Requesting an Argos ADO Connection ==
'''''Instructions for DEPARTMENTS / BUSINESS AREAS '''''
== Requesting an Argos File Operations to Shares ==
Line 10: Line 9:
'''User - ''' '''Instructions for DEPARTMENTS / BUSINESS AREAS '''
Line 12: Line 11:
 1. Complete and review the "Argos - Connection ID Request" form
 1. Discuss the "model process" with your Group Folder Owner
 1. Document either the Model User(s) or Roles List
 1. Get Supervisor approval
 1. Get Group Owner approval
 1. Submit and Route to UTS at [email protected]
 1. Submit a Footprints Ticket - Subject/Desc = "Argos - File Operations (Name of Department)"
 1. Include the following information:
 1. Purpose / Reason for Request:

Path to shares drive/Argos (see note about folder below) -
Example ==> \\shares\<your dept>\Argos (this is NOT your M Drive)
Read Access / Write Access / Both

Note: We are limiting reqeusts to Shares Drives. We recommend that a Folder be placed within your Shares Drive for "Argos".
You will need to put any documents to for Read access into this folder and have DataBlocks save Reports/Extracts to this same direcotry.
You can have sub-folders under the "Argos" folder if you desire.

Add your Supervisor for Approval
Add the Shares Owner for Approval

Submit a separate Request to give the Evisons Service User (svc_evisionsMaps_adm) access to your Share Drive (Argos Folder) \\shares\<your dept>\Argos.
(be sure to specify Read / Write / Both)

Argos File Operations to Shares

Requesting an Argos File Operations to Shares

Instructions for DEPARTMENTS / BUSINESS AREAS

  1. Submit a Footprints Ticket - Subject/Desc = "Argos - File Operations (Name of Department)"
  2. Include the following information:
  3. Purpose / Reason for Request:

Path to shares drive/Argos (see note about folder below) - Example ==> \\shares\<your dept>\Argos (this is NOT your M Drive) Read Access / Write Access / Both

Note: We are limiting reqeusts to Shares Drives. We recommend that a Folder be placed within your Shares Drive for "Argos". You will need to put any documents to for Read access into this folder and have DataBlocks save Reports/Extracts to this same direcotry. You can have sub-folders under the "Argos" folder if you desire.

Add your Supervisor for Approval Add the Shares Owner for Approval

Submit a separate Request to give the Evisons Service User (svc_evisionsMaps_adm) access to your Share Drive (Argos Folder) \\shares\<your dept>\Argos. (be sure to specify Read / Write / Both)

UTS - Argos Admin -

  1. Verify Supervisor and Group Owner approvals
  2. Compile the list of Roles
  3. Identify the applicable Banner Data Stewards based on the List of Roles
  4. List the Roles in the Argos Footprints Ticket by Banner Data Steward
  5. CC all the appropriate Data Stewards for approval
  6. Verify all appropriate Data Stewards have approved
  7. Create or Modify the Argos Group ID; grant the List of Roles
  8. 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;