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
Argument | Description |
---|---|
--config | If specified, create a configuration file after installation that includes Oracle connection credentials |
--createDemoAccount | If 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 |
--dropExisting | If present, drop an existing provendb tables and users if they already exist. |
--oracleConnect | TNS alias for the Oracle service to be connected. |
--provendbPassword | The password to be used for the ProvenDB user |
--provendbUser | The name of the provendb user |
--sysPassword | SYS 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.
Updated over 2 years ago