ALLBASE/SQL Reference Manual (36216-90216)

Appendix A 611
SQL Syntax Summary
RETURN
RETURN [ ReturnStatus ];
REVOKE
Revoke Table or View Authority
REVOKE {ALL [PRIVILEGES]
[SELECT
INSERT
DELETE
ALTER
INDEX
UPDATE [({ ColumnName }[,...])]
REFERENCES [({ ColumnName }[,...])]]|,...|}
ON {[ Owner. ] TableName
[ Owner. } ViewName } FROM { DBEUserID
GroupName
ClassName
PUBLIC }[,...][CASCADE]
Revoke RUN or EXECUTE Authority
REVOKE [RUN ON [ Owner. ] ModuleName
EXECUTE ON PROCEDURE [ Owner. ] ProcedureName ] FROM
{{ DBEUserID
GroupName
ClassName }[,...]
PUBLIC }
Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
REVOKE {CONNECT
DBA
INSTALL [AS OwnerID]
MONITOR
RESOURCE }FROM { DBEUserID
GroupName
ClassName }[,...]
SQL Syntax—Revoke DBEFileSet Authority
REVOKE {SECTIONSPACE
TABLESPACE} |,...| ON DBEFILESET DBEFileSetName FROM
{ { DBEUserID
GroupName
ClassName }[,...]
PUBLIC }
ROLLBACK WORK
ROLLBACK WORK [TO { SavePointNumber
: HostVariable
: LocalVariable
: ProcedureParameter }
RELEASE ]