Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Databank Options


Databanks may be defined with the LOG, TRANSACTION, WORK, or READ ONLY options which determine transaction handling and logging behavior, as follows:

Note: Operations performed on databanks with the TRANSACTION or WORK option cannot be restored in the event of system failure, see Backing-up and Restoring Data.

If a databank is dropped from the database, the tables stored in the databank are also dropped and the physical databank file is deleted from disk.

Creating Idents and a Databank - an Example

In the following example, a databank and two users (idents) are created. The idents are then given the authority to create tables within the databank:

 SQL> CREATE DATABANK DEVELOP SET FILE 'dev.dbf',
             FILESIZE 50 M, OPTION LOG;
 SQL> CREATE IDENT DEVUSER AS USER USING 'devuser';
 SQL> GRANT TABLE ON DEVELOP TO DEVUSER;
 SQL> CREATE IDENT JIM AS USER;
 SQL> ALTER IDENT JIM ADD OS_USER 'JIM';
 SQL> ALTER IDENT JIM ADD OS_USER 'JAMES';
 SQL> GRANT TABLE ON DEVELOP TO JIM;

Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX