GRANT OBJECT PRIVILEGE

Grants object privileges to one or more idents.

grant_object_privilege.png

 

where routine-specification is:

routine_specification.png

 

Usage

Embedded, Interactive, Module, 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 precompiled 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

Grant usage on a domain or user defined type allows the ident(s) to use the domain or the user defined type where a data type would normally be specified. This includes, amongst others, table definitions, routine definitions and cast expression.

When a grant usage on type statement is executed, this will also incur that the ident(s) will receive execute on all functions, on which the grantor has execute privilege with grant option, that were created implicitly when the user defined type was created.

Grant usage on a sequence allows the ident(s) to use the specified sequence in the next value for and current value for expressions.

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-2016

Core

Fully compliant.

SQL-2016

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.