Database Privileges

http://developer.mimer.com

Database Privileges

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

The privileges are grouped as follows:

System privileges
Object privileges
Access privileges.

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.

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.

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.

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.

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