4856
Comment:
|
1791
|
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
- Submit a Footprints Ticket - Subject/Desc = "Argos - File Operations (Name of Department)"
- Include the following information:
- 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
- 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