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

  Enables the ident to perform databank backup and restore operations.

• DATABANK

  Enables 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

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

• SCHEMA

  Enables the ident to create new schemas.

• SHADOW

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

• STATISTICS

  Enables 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.

Example

 GRANT IDENT TO mimer_adm WITH GRANT OPTION;

Standard Compliance

Standard	Compliance	Comments
	Mimer SQL extension	The grant system privileges is a Mimer SQL extension.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se