ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 441

SQL Statements E - R

GRANT

2. Using the WITH GRANT OPTION clause

Clem and George have the SELECT privilege on the Inventory table as well as the

ability to grant the SELECT privilege on this table to other users or a class with the

WITH GRANT OPTION clause or to a group or PUBLIC (without the WITH GRANT

OPTION).

GRANT SELECT

ON PurchDB.Inventory

TO Clem, George WITH GRANT OPTION

3. Module grants

GRANT RUN ON Statistics TO HelperDBA

GRANT RUN ON MyProg TO PUBLIC

Rows associated with module Statistics are deleted from the system catalog.

DROP MODULE Statistics

Authorization information for MyProg is retained, but the program is deleted from the

system catalog. You can re-preprocess MyProg and do not have to redeﬁne its

authorization.

DROP MODULE MyProg PRESERVE

4. Procedure grants

GRANT EXECUTE ON PROCEDURE Process10 TO Managers

GRANT EXECUTE ON PROCEDURE Process12 TO AllUsers

5. DBEFileSet grants

Grant the ability to store sections in DBEFileSet1 to PUBLIC.

GRANT SECTIONSPACE ON DBEFILESET DBEFileSet1 TO PUBLIC;

Grant the ability to store table and long column data in DBEFileSet2 to PUBLIC.

GRANT TABLESPACE ON DBEFILESET DBEFileSet2 TO PUBLIC;

6. Grant authority to run SQLMON

GRANT MONITOR TO HelperDBA;

7. Grant a

DBEUserID

the authority to create modules owned by a speciﬁed

OwnerID

GRANT INSTALL AS John TO Clem;