Changes between Version 1 and Version 2 of newUsers

Timestamp:

06/02/17 14:11:47 (8 years ago)

Author:

lttoth@…

Comment:

--

newUsers

@@ -1 +1 @@
 = 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 -  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:
+Login in as self to RPTP : ssh sx...@rptp.alaska.edu
+Shell from home directory to PROD as ZUASUR : ssh zuausr@prod
+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
+Login in to RPTP :  $ ssh sx...@rptp.alaska.edu
+Open SQLPLUS as ZUAUSR : $ sqlplus zuausr@prod
+Supply ZUAUSR password at prompt
+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 [[https://docs.google.com/document/d/1Q6XzhPsRqwO4OU4nV4f3iMLd9JNwcQq0Ft0NpApsprk/edit|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.
@@ -80 +144 @@
 }}}
 
-