ALLBASE/SQL Reference Manual (36216-90216)

494 Chapter11
SQL Statements E - R
REVOKE
DROP TABLE VendorPerf
3. Using CASCADE
The DBA grants Clem privileges with the ability to grant them to others. Now Clem has
all privileges on the Inventory table as well as the authority to grant any of the
privileges to individual users or a class.
GRANT ALL
ON PurchDB.Inventory
TO Clem WITH GRANT OPTION
Clem grants Amanda all privileges on the Inventory table as well as the authority to
grant any of the privileges to individual users or a class.
GRANT ALL
ON PurchDB.Inventory
TO AMANDA WITH GRANT OPTION
The DBA revokes privileges from both Clem and Amanda.
REVOKE ALL
ON PurchDB.Inventory
FROM Clem CASCADE
4. REVOKE on DBEFileSet
Revoke from PUBLIC the ability to store sections in DBEFileSet1.
REVOKE SECTIONSPACE ON DBEFILESET DBEFileSet1 FROM PUBLIC
Revoke from PUBLIC the ability to store tables and long column data in DBEFileSet2.
REVOKE TABLESPACE ON DBEFILESET DBEFileSet2 FROM PUBLIC
5. Revoke INSTALL or MONITOR authority. Revoke from George the ability to run
SQLMON.
REVOKE MONITOR FROM George;
Revoke from Clem the ability to create modules having any owner name.
REVOKE INSTALL FROM Clem;
Revoke from Clem the ability to create modules owned by JOHN@BROCK.
REVOKE INSTALL AS John FROM Clem;