If the compute cluster administrator user does not exist, create it:
- Log on as user DBC.
- Create the VantageCloud Lake administrative user (for example, ClusterDBA). This user is responsible for compute cluster administration. You may create more than one compute cluster administrator.
For example:
CREATE USER "ClusterDBA" FROM "DBC" AS PERM = 2e5 PASSWORD = "my_password" SPOOL = 11800E9 NO BEFORE JOURNAL NO AFTER JOURNAL;
Where:Field Description Spool Space Optional. The spool space specification is only a limit to the amount of space available for intermediate query results or formatted answer sets to queries and volatile tables. The system borrows spool space for a user from unused permanent space anywhere in the system. Temporary Space Optional. Required only when using global temporary tables and other features that require temporary space. Recommendation: Temporary space is not typically needed. Specify temporary space only when you develop a strategy for using the features that need temporary space. If necessary, you can add a temporary space later with a MODIFY USER statement.
The size of PERM and SPOOL are examples and may differ on your system.
Next, grant privileges to the compute cluster administrators. See Granting CREATE COMPUTE GROUP Privileges to the Compute Cluster Administrator and Granting CREATE COMPUTE PROFILE Privileges to the Vantage Cloud Administrator Profile.