Managing BearDB Database permissions

BearDB has database permissions which can be applied by the dbAdmin using a SQL GRANT statement similar to the following:


The permissions available for the GRANT statement are defined as follows:

  • DB_MODIFYDATA: Can modify table data, either via UPDATE or INSERT.
  • DB_MODIFYTABLE: Can modify table structure, either via CREATE TABLE or ALTER TABLE
  • DB_MODIFYUSER: Can create and modify user accounts, either via CREATE USER or ALTER USER

The permission values are not case-sensitive and can be in upper, lower, or mixed case.

When a new user account is created the account defaults to read data.
When adding a GRANT for a user, each permission has to be added in a separate GRANT statement.
Note that only dbAdmin can drop a user account, regardless of the users permissions.