Adds an IMAGE/SQL user.
Description |
 |
Use the ADD USER command to add a new IMAGE/SQL user.
When a user is added, an SQL authorization group is created that corresponds
to the user class or the user class of the password given in the command.
The new DBEUserID (User@Account) is
then added to this group.
The group is named according to the following conventions:
OwnerName_UserClassNumber
By default, OwnerName is the name of the database (unqualified by its
group and account), but a
different OwnerName can be specified at attach time.
For example, for a database owned by MKTG, the group created for user class
11 is named MKTG_11.
To enforce TurboIMAGE/XL security, one view is created for
each data set the user class is allowed to access.
The view is named according to the following conventions:
OwnerName.MappedTableName_VUserClassNumber
For example, for a database owned by MKTG, the view created for the mapped
table ACCOUNTS is MKTG.ACCOUNTS_V11 for user class 11.
Each view contains only those mapped columns that
correspond to the fields in the data set the user class can
read. The corresponding authorization group is then granted access to these
views.
Example |
|
In the following example, user RYAN.ATC is being added as an IMAGE/SQL user.
The database will be opened in DBOPEN mode 1.
His access to data is the same as that allowed to the password "manager".
Because the password "manager" is associated with user class 18, this number
appears at the end of each view name.
>>ADD USER RYAN.ATC WITH PASS=manager, MODE=1
Warning: command containing a password has been logged (ATCWARN 32069).
ALLBASE/SQL group SALES_18 created.
View SALES.DATE_MASTER_V18 created.
View SALES.CUSTOMER_V18 created.
View SALES.PRODUCT_V18 created.
View SALES.VENDOR_V18 created.
View SALES.INVENTORY_V18 created.
View SALES.SALES_V18 created.
>>
|
In the above example, using CLASS=18 instead of PASS=manager will have the same result.
