www.mimer.com/developer

GRANT SYSTEM PRIVILEGE

---

Grants system privileges to one or more idents.

Usage

Embedded/Interactive/ODBC/JDBC.

Description

The specified system 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.

System Privileges

The system privileges are as follows:

• BACKUP

  Allows the ident to perform databank backup and restore operations.

• DATABANK

  Allows the ident to create new databanks. The databank file is created by the Mimer SQL system. The privilege authorizes the ident to create files, using the file access used by the database server process, in the operating system.

• IDENT

  Allows the ident to create new Mimer SQL idents and schemas.

• SCHEMA

  Allows the ident to create new schemas.

• SHADOW

  Allows the ident to create and perform operations on databank shadows.

• STATISTICS

  Allows the ident to execute the UPDATE STATISTICS statement.

Restrictions

The grantor must have grant option on the privilege.

Notes

An ident may not grant privileges to himself.

Standard Compliance

Standard	Compliance	Comments
X/Open-95 SQL92	MIMER EXTENSION	Support for system privileges is a Mimer SQL extension.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se