Mimer SQL Programmer's Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Access to the Database


The access of each ident to the database is defined by privileges granted within the system.

The privileges are grouped as follows:

System Privileges

Privilege
Explanation
BACKUP
gives the right to perform databank backup and restore operations.
DATABANK
gives the right to create databanks.
IDENT
gives the right to create idents.
SCHEMA
gives the right to create schemas.
SHADOW
gives the right to create and manage databank shadows.
STATISTICS
gives the right to execute the UPDATE STATISTICS statement.

Object Privileges

Privilege
Explanation
TABLE
gives the right to create tables in a specified databank.
EXECUTE
gives the right to call a routine or to enter (connect to) a specified program ident.
MEMBER
grants membership in a specified group ident.
USAGE
gives the right to specify the named domain where a data type would normally be specified (in contexts where use of domains is allowed) or the right to use a specified sequence.

Access Privileges

Privilege
Explanation
SELECT
gives the right to read the table contents.
INSERT
gives the right to add new rows to the table.
DELETE
gives the right to remove rows from the table.
UPDATE
gives the right to update the contents of the table.
REFERENCES
gives the right to use the primary key or unique keys of the table as a foreign key from another table.

About Privileges

System privileges are automatically granted to the system administrator at installation, and may be passed on to other idents. Object and access privileges are initially granted only to the creator of an object. The creator may however grant the privileges on to other idents.

All privileges may be granted with or without GRANT OPTION, which controls the right of the receiving ident to grant the privilege on to another ident.

Certain operations are not controlled by explicit privileges, but may only be performed by the creator of the object involved. These operations include ALTER (with the exception of ALTER IDENT, which may be performed by either the ident himself or by the creator of the ident), DROP, and COMMENT. Similarly, privileges may only be revoked by their grantor.



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