BlazingDB

The BlazingDB Developer Hub

Welcome to the BlazingDB developer hub.

BlazingDB is a SQL database on graphics processing units (GPUs). This allows us to process tons of data very fast. If you want to know a little more check out our "Announcements" section.

You'll find comprehensive guides and documentation to help you start working with BlazingDB as quickly as possible, as well as support if you get stuck.

Get Started    

SQL Permissions

You can grant and revoke access to different databases, tables, views and columns in BlazingDB using GRANT and REVOKE statements.

Syntax

GRANT [permissionType1, permissionType2, ....] ON databaseElement TO [userName or %]

REVOKE [permissionType1, permissionType2, ....] ON databaseElement TO [userName or %]

NOTE: % can be used as a wildcard to refer to all users.

The permission types that can be set depend on what the permissions are being applied to.

Databases permissions

Permission types possible:

  • create
  • drop
  • create view
  • grant option

Example:

GRANT create, drop, create view, grant option ON demoDatabase TO %

REVOKE create, drop, create view, grant option ON accounts TO no_good_user

Tables permissions

Permission types possible:

  • select(columnA, columnB, ...)
  • insert
  • delete
  • drop
  • grant option

Example:

GRANT select(column1,column2), insert, delete, drop, grant option ON databaseA.tableB TO userName

REVOKE insert, delete, drop, grant option ON databaseB.tableX TO readonlyUser

Views permissions

Permission types possible:

  • select(columnA, columnB, ...)
  • drop
  • grant option

Example:

GRANT select(column1,columnN), drop, grant option ON databaseA.viewName TO %

REVOKE select(columnY), drop, grant option ON databaseA.viewName TO janeDoe

SQL Permissions