Creating a PPUPDATE User on Oracle Server

The PPUPDATE user is used to store Prognoz Platform 9 distribution kit at database server. The distribution kit is saved to this user database and is taken from there on Prognoz Platform 9 update at user workstations. Creating a user requires:

A user can be created using the following script:

CREATE USER PPUPDATE IDENTIFIED BY PPUPDATE DEFAULT TABLESPACE Users TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;

GRANT CONNECT TO PPUPDATE;

GRANT RESOURCE TO PPUPDATE;

REVOKE UNLIMITED TABLESPACE FROM PPUPDATE;

ALTER USER PPUPDATE QUOTA UNLIMITED ON Users;

COMMIT;

Where Users is the name of tablespace, in which the PPUPDATE user is created.

The script must be run using standard database management methods under the name of a user who has permissions to create users at the database server.

NOTE. In Oracle 12c Release 1 or later the "resource" role does not give the "unlimited" privilege. The attempt to get this privilege will result in error. On using Oracle 12c Release 1 server or later skip the command:
REVOKE UNLIMITED TABLESPACE FROM PPUPDATE.

Use standard database management methods to run the following script under the name of previously created PPUPDATE user:

create table B_UPD (

LNAME VARCHAR2(127) not null,

UPD NUMBER(8,0) not null,

STAMP DATE not null,

FNAME VARCHAR2(127) not null,

DNAME VARCHAR2(127),

FSIZE NUMBER(24,4)

)

alter table B_UPD

add constraint PK_B_UPD primary key (LNAME, UPD)

create table B_UPDD (

LNAME VARCHAR2(127) not null,

UPD NUMBER(8,0) not null,

DAT LONG RAW

)

alter table B_UPDD

add constraint PK_B_UPDD primary key (LNAME, UPD)

alter table B_UPDD

add constraint FK_UPDD2UPD foreign key (LNAME, UPD)

references B_UPD (LNAME, UPD)

on delete cascade

After all the steps have been completed successfully, the PPUPDATE user can be used to create a copy of Prognoz Platform 9 version to be updated at database server.