...
| Warning |
|---|
Start from really simple, using tar, to using script and then advanced using replication. |
Adding Users
There is a need to have multiple users for administration of the HSQL database. The administrator account is "SA" and has all privileges including create, read and write. The pubic users run through the "twokeysursis" account and have read only access. For managing the database, all 2Keys employees have their own accounts that include read and write, but not create.
To add a user, use the following syntax
| Code Block | ||
|---|---|---|
| ||
CREATE USER sheeley password "<password>" |
...
GRANT SELECT ON APP_COMM TO sheeley; |
...
GRANT INSERT ON APP_COMM TO sheeley; |
...
GRANT UPDATE ON APP_COMM TO sheeley; |
...
GRANT SELECT ON BUNDLE TO sheeley; |
...
GRANT INSERT ON BUNDLE TO sheeley; |
...
GRANT UPDATE ON BUNDLE TO sheeley; |
...
GRANT SELECT ON RESOURCE TO sheeley; |
...
GRANT INSERT ON RESOURCE TO sheeley; |
...
GRANT UPDATE ON RESOURCE TO sheeley; |
Changing Password
The syntax command for changing the password
...