Managing BearDB Database permissions
BearDB has database permissions which can be applied by the dbAdmin using a SQL GRANT statement similar to the following:
GRANT USER bob ACCESS DB_MODIFYDATA
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.