Create Cockroach DB database and user





Here are the steps to create cockroach db database and uses of cockroach db database.

Create CockroachDB database : 
CREATE DATABASE cockroachdb;


Create CockroachDB Database User : 
CREATE USER cockroachdb WITH PASSWORD 'vishal';   


Grant Privileges on CockroachDB Databases : 
GRANT CREATE ON DATABASE cockroachdb TO cockroachuser;
GRANT ALL ON TABLE cockroachdb.* TO cockroachuser;




Privilege 
Levels
ALL Database, Table
CREATE Database, Table
DROP Database, Table
GRANT Database, Table
SELECT Table
INSERT Table
DELETE Table
UPDATE Table