Alternative Syntax Using AS username
The non-standard AS
clause is supported as a synonym of the GRANTED BY
clause to simplify migration from other database systems.
AS username
The non-standard AS
clause is supported as a synonym of the GRANTED BY
clause to simplify migration from other database systems.
For tables and views, unlike other metadata objects, it is possible to grant several privileges at once.
SELECT
Permits the user or object to SELECT
data from the table or view
INSERT
Permits the user or object to INSERT
rows into the table or view
DELETE
Permits the user or object to DELETE
rows from the table or view
UPDATE
Permits the user or object to UPDATE
rows in the table or view, optionally restricted to specific columns
REFERENCES
Permits the user or object to reference the table via a foreign key, optionally restricted to the specified columns.If the primary or unique key referenced by the foreign key of the other table is composite then all columns of the key must be specified.
ALL [PRIVILEGES]
Combines SELECT
, INSERT
, UPDATE
, DELETE
and REFERENCES
privileges in a single package