Managing DBLX Database permissions


DBLX 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.

 
 

DBLX SQL Guide