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. |
Parent topic: Provision a Database User