5 Database Utilities

Example script

# connect to server

ONNECT "server:8800";
LOGON "dba" PASSWORD "dbat";

# create user mike with an associated password "secret"
# and allow connection to the database server
# this is global to all databases

CREATE USER "mike" PASSWORD "secret";
GRANT CONNECT TO "mike";

# now switch to database "db"

DATABASE "db";

# create group users.
# let members of group users read/write all sets

CREATE GROUP "users";
GRANT WRITE ON ALL TO "users";

# create group priv.
# let members of group priv erase the set "HISTORY"

CREATE GROUP "priv";
GRANT ERASE ON "HISTORY" TO "priv";

# now let mike become member of groups "users" and "priv"

GRANT "users","priv" TO "mike";