Differences between revisions 2 and 3
Revision 2 as of 2019-11-15 14:06:14
Size: 4856
Editor: cox
Comment:
Revision 3 as of 2019-11-15 14:07:24
Size: 1791
Editor: cox
Comment:
Deletions are marked like this. Additions are marked like this.
Line 9: Line 9:
'''Instructions for DEPARTMENTS / BUSINESS AREAS ''' === Instructions for DEPARTMENTS / BUSINESS AREAS ===
Line 29: Line 29:
'''UTS - Argos Admin - ''' === UTS - Argos Admin ===
Line 39: Line 39:


== 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;
}}}
--------
''' '''

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