GRANT SYSTEM PRIVILEGE

Grants system privileges to one or more idents.

grant_system_privilege.png

 

Usage

Embedded/Interactive/Module/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 and DELETE STATISTICS statements.

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.