wiki:newUsers
Last modified 2 years ago Last modified on 02/01/18 11:51:44

Creating New Users

Users fall into 3 basic categories:

  • OIT - SX accounts
  • Regular Staff and Student Employees
  • Consultants and VA Interns

OIT - SX Accounts

OIT staff are designated by the prefix of "sx". When the zuaseed.ksh script is executed, it will produce all the information that is needed to create the OIT staff account with the exception of the actual Banner User ID. That will start with "sn" and is not to be used. An example result of running the zuaseed.ksh script follows.

tongas -- /users/zu/zuausr > zuaseed.ksh 31198466

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 2 14:03:26 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

.        User ID (30mil): 31xxxxxx
.        Audit/[U]pdate : U
.             Last Name : Hovercraft
.            First Name : Nicole
.           Middle Name : Dawn
.               Student : N
.                   TKL : T180
.                  ECLS : XR
.           Prefix Area : f
.         Employee Type : n
.    Employee Term Date : NONE
.   Empl Last Work Date : NONE
.              ID regex : ^[f][nx][a-z]+(\d|1\d)?$
.              Position : 208656/00-Administrative Management 1 TERM_DATE:NONE
.               Base ID : snndh7
.           Full new ID : snndh7
.                 MISC2 : Hovercraft/Nicole Dawn,,sn.AP.T802.XR.,IS Consultant 3A;OIT Support Center

PL/SQL procedure successfully completed.

Generate ZUAUSR_LOAD entry? (y[N]): 

...

Using the data show above, the following steps are followed to create a SW OIT Banner User ID:

  1. Login in as self to RPTP : ssh sx...@…
  2. Shell from home directory to PROD as ZUASUR : ssh zuausr@prod
  3. From the command line run the creation script with the new user's UA ID as input
    • $ zuaseed.ksh 3xxxxxxx
    • Keep the results of the screen available for copy/paste into the table
    • Enter 'N' at first prompt
    • Enter 'N' at second prompt
  4. Login in to RPTP : $ ssh sx...@…
  5. Open SQLPLUS as ZUAUSR : $ sqlplus zuausr@prod
  6. Supply ZUAUSR password at prompt
  7. Run the following query for both ZTBUSRH and ZTBUSRH_LOAD
    INSERT INTO ztbusrh<_load>
    (
     ztbusrh_user_acct_id, ztbusrh_user_uid, ztbusrh_first_name, ztbusrh_last_name,
     ztbusrh_middle_initial, ztbusrh_ssn, ztbusrh_misc1, ztbusrh_misc2
    )
    values
    (
     'sxndh7', -1, 'Nicole', 'Hovercraft',
     'D', <SSN>, '-1', 'Hovercraft/Nicole Dawn,,sn.AP.T802.XR.,IS Consultant 3A;OIT Support Center'
    )
    

Regular Staff and Student Employees

Both the old manual process for creating new employees and a description of the new process can be found in UA - Role Provisioning Operations Manual. The old process description is useful in that it provides a listing of campus prefixes which comes in handy for Consultant and VA Work Study Banner User ID creation.

The current process follows the following steps:

  1. Security Coordinators open a Cherwell Ticket under the category Account Management. The ticket includes:
    1. Campus
    2. UA ID (3xxxxxxx)
    3. The user's full name
  2. A Zuausr Administrator claims the ticket and runs the user creation script:
    1. Login in as self to RPTP : ssh sx...@…
    2. Shell from home directory to PROD as ZUASUR : ssh zuausr@prod
    3. From the command line run the creation script with the new user's UA ID as input
      • $ zuaseed.ksh 3xxxxxxx
      • Enter Y at first prompt to create the account
      • Enter Y at the second prompt if there are no other new user creations pending; step 2 can be applied to several users
    4. Handle any errors that arise, commonly by informing the requesting Security Coordinator of the results
      • An ID already exists for the user
      • The user has transferred from one campus to another and the old ID is still for that campus
      • The user has not been entered into appropriate tables by HR

Consultants and VA Interns

Consultants and VA Interns must be entered via SQL. The data must be entered into both ztbusrh and ztbusrh_load. For this reason, ZUAUSR administrators must be logged into SQLPLUS as zuausr@prod. The basic template is the same, but some features of the data entered differ.

  • IDS Creation
    • Unique Ids are determined by ZUAUSR administrators for consultants based on the initials of the first and last name of the user and one to two letters representing the company for which they work.
    • VA students are determined by ZUAUSR administrators based on first, last, and middle initial as other users, adding numbers if necessary
  • Default Password
    • Consultants do not have SSN numbers: the letters 'cs'+ the first 8 numbers of their office phone provides the default password normally found under UID.
    • VA Interns do have SSN numbers: These are queried in Banner
  • ZTBUSRH_MISC2
    • Consultants will be identified by Department for which they work: <Last>/First CompanyUA Department
    • VA Interns are categorized solely by campus: UA<c> - VA Work Study, e.g., UAA - VA Work Study
  • Ending Date
    • Consultant end dates are based on contract length
    • VA Intern end dates are based on semesters and renewed when the student remains on staff
  • ZTBUSRH_USER_UID
    • Consultants will not have a Banner PIDM, the key used to connect various Banner tables
    • VA Students may have a PIDM and if known, may be supplied in the record creation

Template for Consultants

Only the query for inserting into ztbusrh load is listed below. The identical query is run for ztbusrh_load by replacing ztbusrh_load after INTO. The following steps outline how to insert a consultant into ZUAUSR.

  1. Determine which campus prefix is needed based on the list in UA - Role Provisioning Operations Manual.
  2. Add the consultant's information to Google document located under ZUAUSR Administrative Documents: Consultant Records
  3. Login in to RPTP : $ ssh sx...@…
  4. Open SQLPLUS as ZUAUSR : $ sqlplus zuausr@prod
  5. Supply ZUAUSR password at prompt
  6. Run the following query for both ZTBUSRH and ZTBUSRH_LOAD
    INSERT INTO ztbusrh<_load>
    (
     ztbusrh_user_acct_id, ztbusrh_user_uid, ztbusrh_first_name, ztbusrh_last_name,
     ztbusrh_middle_initial, ztbusrh_ssn, ztbusrh_misc1, ztbusrh_misc2,
     ztbusrh_last_work_date
    )
    values
    (
     user ID, -1, <first>, <last>,
     <Company initials>, cs<nnnnnnn>, '-1', 'Last/First Co.,,UA Campus/Department',
     to_date('31-May-2018','DD-MON-YYYY')
    )
    

Query Template for VA Interns

Only the query for inserting into ztbusrh load is listed below. The identical query is run for ztbusrh_load by replacing ztbusrh_load after INTO. The following steps outline how to insert a consultant into ZUAUSR.

  1. Login in to RPTP : $ ssh sx...@…
  2. Open SQLPLUS as ZUAUSR : $ sqlplus zuausr@prod
  3. Supply ZUAUSR password at prompt
  4. Run the following query for both ZTBUSRH and ZTBUSRH_LOAD
    INSERT INTO ztbusrh<_load>
    (
     ztbusrh_user_acct_id, ztbusrh_user_uid, ztbusrh_first_name, ztbusrh_last_name,
     ztbusrh_middle_initial, ztbusrh_ssn, ztbusrh_misc1, ztbusrh_misc2
    )
    values
    (
     user ID, -1, <first>, <last>,
     <Middle>, SSN, '-1', 'Last/First Co.,,UA<c> - VA Work Study'
    )