GRANT OBJECT PRIVILEGE

---

Grants object privileges to one or more idents.

where routine-specification is:

Usage

Embedded/Interactive/ODBC/JDBC.

Description

The specified object privilege is granted to the ident(s) listed. When WITH GRANT OPTION is specified, the ident may in turn grant the specified privilege to another ident. If the privilege is granted to a GROUP ident, all members of the group receive the specified privilege.

Object Privileges

The object privileges are as follows:

• EXECUTE

  Allows the ident to invoke the specified function, procedure or statement, or to enter the specified PROGRAM ident.

• MEMBER

  Specifies that the ident is a member of the stated group. All privileges granted to the group are held by all members of the group.

• SEQUENCE

  Allows the ident to create new sequences in the specified databank.

• TABLE

  Allows the ident to create new tables in the specified databank.

• USAGE

  allows the ident to specify the named domain where a data type would normally be specified, in contexts where use of domains is allowed or to use the value of a sequence, in contexts where this is allowed.

Restrictions

The grantor must have grant option on the privilege.

Notes

If the grantor loses his grant option, any privileges he has granted using the option are automatically revoked.

An ident may not grant privileges to himself.

An ident may gain WITH GRANT OPTION because of the effect of a `cascading grant' in the following situation:

If an ident creates an object that references at least one other object on which the ident holds an object privilege without WITH GRANT OPTION, the ident will not hold WITH GRANT OPTION on the created object.

Example

 GRANT EXECUTE ON FUNCTION capitalize TO mimer_admin_group;

Standard Compliance

Standard	Compliance	Comments
SQL-2003	Core	Fully compliant.
SQL-2003	Features outside core	Feature F251, "Domain support" support for grant usage on domain. Feature F691, "Collations and translations" support for grant usage on collation.
	Mimer SQL extension	Support for use of MEMBER, EXECUTE (on STATEMENT and PROGRAM), SEQUENCE and TABLE are Mimer SQL extensions.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se