Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


GRANT ACCESS PRIVILEGE


Grants one or more access privileges on a table or view.

where access is:

Usage

Embedded/Interactive/ODBC/JDBC.

Description

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

Access Privileges

The access privileges are as follows:

Access privileges may be granted in any combination. Specification of the keyword ALL (followed by the optional keyword PRIVILEGES) instead of an explicit list of access privileges results in all applicable privileges being granted to the specified ident(s) (i.e. all privileges which the grantor is authorized to grant).

Restrictions

The grantor must have grant option on the access privilege.

Notes

If the grantor loses WITH GRANT OPTION, any access privileges he has granted using it are automatically revoked.

An ident may not grant access 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 object on which the ident holds an access privilege without WITH GRANT OPTION, the ident will not hold WITH GRANT OPTION on the created object.

Example

The following example is taken from the Mimer SQL User's Manual, chapter 10, Granting Access Privileges.

 GRANT SELECT, UPDATE(exchange_rate) ON currencies TO mimer_admin_group;

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
YES
Use of the keyword PRIVILEGES after the keyword ALL is optional in Mimer SQL, not mandatory.



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