Controlling Access to Objects

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