cockroachdb default password code example

Example: CockroachDB create user

#Create User
CREATE USER <CREATEDUSER> WITH PASSWORD '<PASSWORD>';

#Grants Permission for database or table
GRANT SELECT, INSERT, UPDATE, DELETE ON DATABASE <DATABASENAME> TO <CREATEDUSER>;

#Revoke access from database or table
REVOKE SELECT ON DATABASE <DATABASENAME> FROM <USER_OR_ROLE>;