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