[228] in Tooltime
Re: Database changes/ Documentation
daemon@ATHENA.MIT.EDU (Steven Wade Neiterman)
Fri Sep 6 10:31:10 1996
Date: Fri, 6 Sep 1996 10:31:59 +0100
To: "Lynne E. Sousa" <sousa@MIT.EDU>
From: wade@MIT.EDU (Steven Wade Neiterman)
Cc: tooltime@MIT.EDU
At 3:34 PM 9/5/96, Lynne E. Sousa wrote:
>Good Afternoon,
>
>Have you had a chance to make the changes?
I will work on the changes as part of the Filemaker migration this morning.
>
>I am also still waiting on the instructions for adding and deleting users.
>
Until I write a script to create a new user, here are the individual steps:
1. Create Oracle account for user and set proper grants
/u2/scopus/scopus.3.6.2/apps/base/install/oracle/bin/ora_addlogin
Syntax:
ora_addlogin <administrator_id>/<passwd> new_user new_pwd
NOTE: check for error messages.
2. Using the Scopus Contact Screen, create a user. This is available
via the Unix (Solaris) SupportTEAMplus application. Enter the consultant
first name, last name and set organization to MIT.
NOTE: Record the userid created as this will be used in step 3. The key
field on the screen will be filled in after saving the record.
3. Update Scopus profile table with userid and access control
a. Invoke sqlplus, environment variables should be set as follows:
setenv SCOPUS /mit/tooltime/scopus
setenv SQLNET_TYPE V2
setenv OP_HOST help-them.mit.edu
setenv OP_LOGIN
setenv OP_DBNAME helpus
setenv ORACLE_BASE /mit/tooltime/oracle
setenv ORACLE_HOME /mit/tooltime/oracle/product/7.1.4
setenv ORACLE_SID helpus
b. Login using user dbo
c. Issue the following sql command:
insert into profiles
(login_name,userid,security_level,delta_ts,delta_sy_user)
values (kerberos principle,94,'ISHELP',date);
Example:
insert into profiles
(login_name,userid,security_level,delta_ts,delta_sy_user)
values ('wade',94,'ISHELP','16-MAY-96',1);
4. Issue the following sql command while in sqlplus:
update users set users.employee_flag = 'Y' where
lastname = 'enter name typed in contact screen';
or just use:
"update users set users.employee_flag = 'Y';"
to update all records in the table without selecting a specific record.
NOTE: This step should not be needed, but we found that the Contact
screen in step 3 above has a bug and does not properly set
this flag. So, we do it manually.
