HP 3000 Manuals

ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL

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

MPE/iX 5.0 Documentation