See Users for details about users within
Kinetica.Users can be added to the system and assigned
permissions either directly or via
roles.Optionally, the user can be associated with a
resource group and/or be assigned a
default schema.
The password needs to be single-quoted and must not contain single quotes.
Examples
Two of the ways to create a new internal user with the user ID of
jsmith and a password of secret are:
CREATE USER jsmith IDENTIFIED BY 'secret'
CREATE USER jsmith WITH PASSWORD 'secret'
To create an internal user with the user ID of jsmith, a password of
secret, and assigning the memory_over_executionresource group:
CREATE USER with Resource Group Example
CREATE USER jsmithIDENTIFIED BY 'secret'WITH RESOURCE GROUP memory_over_execution
To create a user with an existing external LDAP user, the user name should match
the LDAP user name and be prepended with the @ symbol; no password is
supplied, as the user will be externally authenticated:
CREATE USER (External) Example
CREATE USER "@jsmith"
Assistant
Responses are generated using AI and may contain mistakes.