Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


GRANT OBJECT PRIVILEGE


Grants object privileges to one or more idents.

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:

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.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL92
EXTENDED
Support for the keywords EXECUTE, MEMBER and TABLE is a Mimer SQL extension.
Support for GRANT USAGE ON SEQUENCE is a Mimer SQL extension.
SQL/PSM
EXTENDED
Support for EXECUTE ON PROGRAM and the privileges MEMBER and TABLE is a Mimer SQL extension.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX