4.1.1.1 Usage

./TSAMDBUserProvision.sh -connStr <connection string> -adminUser <admin username> -user <new user> -tablespace <tablespace> [-adb] [-walletDir <path to DB wallet>] [-dropUser] [-quota <quota limit>] [-enableAI] [-aiUser <new aiUser>] [-aiSourceMode <CLOUD|LOCAL>]

Table 4-1 Parameter List

Name Description
-connStr <connection string> DB connection string. If the connection string contains spaces or special characters like parentheses, enclose it in double quotes.
-adminUser <admin username> The administrative user with privileges to create users.
-aiSourceMode <CLOUD|LOCAL> Optional. Specifies the AI source mode. The default value is CLOUD. LOCAL is supported only for non-ADB deployments.
-user <new user> The name of the new database user to be created.
-tablespace <tablespace> The tablespace for the new user.
-adb (Optional) Flag to indicate Autonomous Database.
-walletDir <path to DB wallet> (Optional) Path to the wallet directory.
-dropUser (Optional) Drop the user if it already exists, then recreate.
-quota <quota limit> (Optional) Quota for the user on the tablespace. Examples: 100M, 1G, UNLIMITED. Default is UNLIMITED if not provided.
-enableAI (Optional) Flag to grant Select-AI related privileges (DBMS_CLOUD, DBMS_CLOUD_AI, etc.). This is required to use Oracle TSAM Plus AI-based Operation Assistant feature.
-enableAI -aiUser <new aiUser> Required when -enableAI is set. The database AI user used for TSAM Plus AI-based Operation Assistant.

Note:

Before running TSAMDBSchemaSetup.sh with -enableAI, set AI_VECTORINDEX_SOURCE_MODE in TSAMSetup.cfg. TSAMDBSchemaSetup.sh does not accept -aiSourceMode as a command-line parameter.
-h or -help (Optional) Show help message.