admin
superuser is created by default. The admin
superuser is granted all privileges on all database objects. Superusers can create new users that, by default, have no database object privileges.ALL
privileges on a table created by that user.user1
by granting a role to user1
and by directly granting a privilege. This example presumes that table1
and user1
already exist, and that user1
has ACCESS privileges on the database where table1
exists.r_select
role.table1
to the r_select
role. Any user granted the r_select
role gains the SELECT privilege.r_select
role to user1
, giving user1
the SELECT privilege on table1
.user1
the INSERT privilege on table1
.INSERT
, SELECT
, DELETE
, UPDATE
, DROP
, or TRUNCATE
privilege or specify all privileges.ALL
ALTER TABLE
DELETE
DROP
INSERT
SELECT
TRUNCATE
UPDATE
role
user
employees
table for the payrollDept role.employees
table for user chris.employees
table for the hrdept and accountsPayableDept roles.employees
table for the role hrDept and for users dennis and mike.INSERT
, SELECT
, DELETE
, UPDATE
, or TRUNCATE
privileges, or remove all privileges.ALL
ALTER TABLE
DELETE
DROP
INSERT
SELECT
TRUNCATE
UPDATE
role
user
employees
table for the nonemployee role.directors
table for the employee role.directors
table for role employee and user laura.employees
table for the role nonemployee and for users dennis and mike.SELECT
, INSERT
, or DROP
privileges, or specify all privileges.ALL
DROP
INSERT
SELECT
role
user
employees
view for the payrollDept role.employees
view for the employee role and user venkat.employees
view for the hrDept and acctPayableDept roles and users simon and dmitri.INSERT
, DROP
, or SELECT
privileges, or remove all privileges.ALL
DROP
INSERT
SELECT
role
user
employees
view for the nonemployee role.directors
view for the employee role.directors
view for the employee and manager role and for users ashish and lindsey.ACCESS
ALL
ALTER TABLE
ALTER SERVER
CREATE SERVER
CREATE TABLE
CREATE
.CREATE VIEW
CREATE DASHBOARD
CREATE
DELETE
DELETE DASHBOARD
DROP
DROP SERVER
DROP VIEW
EDIT DASHBOARD
INSERT
SELECT
SELECT VIEW
SERVER USAGE
role
user
companydb
database for the payrollDept role and user david.companydb
database for the employee role.companydb
database for the hrdept and manager role and for users irene and stephen.ACCESS
ALL
ALTER SERVER
ALTER TABLE
CREATE TABLE
CREATE
.CREATE VIEW
CREATE DASHBOARD
CREATE
CREATE SERVER
DELETE
DELETE DASHBOARD
DROP
DROP SERVER
DROP VIEW
EDIT DASHBOARD
INSERT
SELECT
SELECT VIEW
SERVER USAGE
role
user
employees
database for the nonemployee role.directors
database for the employee role and for user monica.directors
database for employee role and for users max and alex.DROP
ALTER
USAGE
role
user
parquet_s3_server
to user fred:parquet_s3_server
to role payrollDept:parquet_s3_server
to role payrollDept and user jamie:DROP
ALTER
USAGE
role
user
parquet_s3_server
for user inga:parquet_s3_server
for role payrollDept:parquet_s3_server
for role payrollDept and user marvin:ALL
CREATE
DELETE
EDIT
VIEW
\dash
command when logged in as superuser.role
user
740
for the payrollDept role.730
for the hrDept role and user dennis.740
for the hrDept and accountsPayableDept roles and for user pavan.ALL
CREATE
DELETE
EDIT
VIEW
role
user
740
for the payrollDept role.730
for hrDept role and users dennis and mike.740
for the hrDept and accountsPayableDept roles and for users dante and jonathan.GRANT ACCESS ON DATABASE <dbName> TO <entityList>;
GRANT CREATE TABLE ON DATABASE <dbName> TO <entityList>;
GRANT SELECT ON TABLE <tableName> TO <entityList>;
GRANT VIEW ON DASHBOARD <dashboardId> TO <entityList>;
GRANT CREATE DASHBOARD ON DATABASE <dbName> TO <entityList>;
GRANT EDIT ON DASHBOARD TO ;
GRANT DELETE DASHBOARD ON DATABASE <dbName> TO <entityList>;
table1
through table4
are created as needed:\dash
command to list all dashboards and their unique IDs in HEAVY.AI: