Previous Next JavaScript must be enabled to correctly display this content

## 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.