Install command

The ProvenDB for Oracle install command installs Oracle tables and users.

The ProvenDB for Oracle utility relies on control tables stored within the target Oracle database. These tables are owned by an Oracle user who must also have read access to Oracle tables that are to be anchored.

The install command will create this user, the control tables and optionally a demo account. The install command has the following usage:

~ % provendb-oracle install --help
Installs the ProvenDB for Oracle users and tables

USAGE
  $ provendb-oracle install

OPTIONS
  -v, --verbose                        increased logging verbosity
  --config=config                      Create config file
  --createDemoAccount                  Create the ProofableDemo account
  --dropExisting                       Drop existing users if they exist
  --oracleConnect=oracleConnect        (required) Oracle connection String
  --provendbPassword=provendbPassword  (required) ProvenDB User Password
  --provendbUser=provendbUser          [default: provendb] ProvenDB User Name (defaut: provendb)
  --sysPassword=sysPassword            SYS Password
ArgumentDescription
--configIf specified, create a configuration file after installation that includes Oracle connection credentials
--createDemoAccountIf specified, creates a demo account containing the tables that are used in examples. This account will be named {user}Demo where {user} is the account specified in the provendbUser arguments
--dropExistingIf present, drop an existing provendb tables and users if they already exist.
--oracleConnectTNS alias for the Oracle service to be connected.
--provendbPasswordThe password to be used for the ProvenDB user
--provendbUserThe name of the provendb user
--sysPasswordSYS password which will be used to install Oracle user. If not provided, the installer will prompt for the password.

Privileges granted to the Oracle user

The installer will grant the following privileges to the Oracle user

CONNECT
RESOURCE
CREATE SESSION
SELECT_CATALOG_ROLE
UNLIMITED TABLESPACE
CREATE VIEW
SELECT ANY TABLE
ALTER SESSION
FLASHBACK ANY TABLE
EXECUTE_CATALOG_ROLE
EXECUTE on DBMS_SESSION

Manually creating the Oracle user

In some circumstances, you may wish to manually create the Oracle user to avoid granting all of the privileges listed above. In this case you can run installProvenDBOracle.sql script available from the provendb.com downloads page. Edit the file to remove any unwanted privileges. You cannot, however, run against an account which does not have the PROVENDBCONTROL and PROVENDBCONTROLROWIDS table.

The demo account

The Demo account contains the CONTRACTSTABLE and CONTRACTSTABLEFBDA tables. These tables are used in demonstration examples for ProvenDB for Oracle.


What’s Next