You can use ISQL to grant or revoke various privileges on data
objects as follows:
isql=> GRANT SELECT ON MyTable to User1;
User1 is granted authority to retrieve data on MyTable.
|
Statements used to control access to the DBEnvironment are
collectively referred to as data control language (DCL)
statements. Refer to the "SQL Statements" chapter of the
ALLBASE/SQL Reference Manual for complete information on using the following SQL data control statements:
GRANT
REVOKE
CREATE GROUP
DROP GROUP
ADD TO GROUP
REMOVE FROM GROUP
TRANSFER OWNERSHIP
|