execute

execute <statement>

The execute command in Oracle NoSQL Database should be used to run the SQL statements required to create an admin user and grant readwrite privileges to the user. You must enclose the SQL statement in single or double quotes. The execute command runs the statement synchronously.

You can use the below command to create an admin user. The user created has full administrative privileges.

kv-> execute 'create user <username> IDENTIFIED BY "<password>" ADMIN'
Statement completed successfully

You can grant read and write privileges to the admin user as shown below.

kv-> execute 'GRANT readwrite to USER <username>'
Statement completed successfully

Once you have created the admin user and granted the required privileges, you must connect to the SQL shell to perform other DDL or DML operations.