1.1.1

Example
To grant the SELECT privilege on table "t" to the authorization IDs "sam" and "bob:"
GRANT SELECT ON TABLE t TO sam,bob;
To grant the UPDATE and TRIGGER privileges on table "t" to the authorization IDs
"sagarika" and "czhu:"
GRANT UPDATE, TRIGGER ON TABLE t TO sagarika,czhu;
To grant the SELECT privilege on table "test.sample" to all users:
GRANT SELECT ON TABLE test.sample to PUBLIC;
To grant the EXECUTE privilege on procedure"p" to the authorization ID "richard:"
GRANT EXECUTE ON PROCEDURE p TO richard;
INSERT
An INSERT statement creates a row or rows and stores them in the named table. The number of values assigned
in an INSERT statement must be the same as the number of specified or implied columns.
Syntax
INSERT INTO table-name
[ ( simple-column-name [ , simple-column-name ]* ) ]
Query
Description
Query can be:
• a VALUES list
• a multiple-row VALUES expression
Note: SQLFire does not support an INSERT with a subselect query if any subselect query requires
aggregation.
Single-row and multiple-row lists can include the keyword DEFAULT. Specifying DEFAULT for a column
inserts the column's default value into the column. Another way to insert the default value into the column is to
omit the column from the column list and only insert values into other columns in the table. More information
is provided in VALUES Expression on page 544.
SELECT on page 528 and JOIN Operations on page 551 provide additional information.
Statement dependency system
The INSERT statement depends on the table being inserted into, all of the conglomerates (units of storage such
as heaps or indexes) for that table, and any other table named in the statement. Any statement that creates or
drops an index or a constraint for the target table of a prepared INSERT statement invalidates the prepared
INSERT statement.
Example
INSERT INTO TRADE.CUSTOMERS
VALUES (1, 'J Pearson', '07-06-2002', 'VMWare', 1);
-- Insert a new customer into the CUSTOMERS table,
vFabric SQLFire User's Guide524
vFabric SQLFire Reference