ALLBASE/SQL Reference Manual (36216-90216)

436 Chapter11
SQL Statements E - R
GRANT
GRANT
The GRANT statement gives specified authority to one or more users or authorization
groups. The following forms of the GRANT statement are described individually:
• Grant table or view authority.
• Grant RUN or EXECUTE authority.
• Grant CONNECT, DBA, INSTALL, MONITOR, or RESOURCE authority.
• Grant SECTIONSPACE or TABLESPACE authority for a DBEFileSet.
For detailed information about security schemes, refer to the "DBEnvironment
Configuration and Security" chapter of the ALLBASE/SQL Database Administration
Guide.
Scope
ISQL or Application Programs
SQL Syntax — Grant Table or View Authority
GRANT {ALL [PRIVILEGES]
{SELECT
INSERT
DELETE
ALTER
INDEX
UPDATE [({ ColumnName }[,...])]
REFERENCES [({ ColumnName }[,...])]}|,...|}
ON {[ Owner. ] TableName
[ Owner. ] ViewName }TO { DBEUserID
GroupName
ClassName
PUBLIC } [,...][WITH GRANT OPTION]
[BY { DBEUserID
ClassName }]
Parameters — Grant Table or View Authority
ALL [PRIVILEGES] is the same as specifying all privileges you can grant on that table or
view. For OWNER or DBA the privileges are SELECT, INSERT, DELETE,
ALTER, INDEX, UPDATE, and REFERENCES. The word PRIVILEGES
is not required; you can include it if you wish to improve readability.
ALTER, INDEX, and REFERENCES are not applied when using GRANT
ALL on views.
SELECT grants authority to retrieve data.
INSERT grants authority to insert rows.
DELETE grants authority to delete rows.