Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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:

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.

Example

 GRANT EXECUTE ON FUNCTION capitalize TO mimer_admin_group;

Standard Compliance

Standard
Compliance
Comments
SQL-2011
Core
Fully compliant.
SQL-2011
Features outside core
Feature F251, "Domain support" support for grant usage on domain.
Feature F690, "Collation support" 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
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX