Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: InterBase/Server/Internal/DSQL    [ Add a report in this area ]  
Report #:  1090   Status: Reported
isc4.gdb -> master.gdb with much more functionality
Project:  InterBase Build #:  OE
Version:    6.5 Submitted By:   Arno Brinkman
Report Type:  New Feature Request Date Reported:  5/1/2002 11:44:12 AM
Severity:    Commonly encountered problem Last Updated: 5/2/2003 12:58:35 PM
Platform:    All versions Internal Tracking #:  
Resolution: None  Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: (4 Total Ratings)
3.00 out of 5
Total Votes: None
Description
See Steps.
Just some very missing features.
Steps to Reproduce:
----------------
First of all rename the isc4.gdb to a "master" database.
Further the "master" database must be accessible from any connection (ofcourse when the user has it's rights for that).
Connection-info must be available through tables.
For example :

SELECT
  Workstation,
  IP,
  UserName,
  ApllicationName
FROM
  Master.Connections
WHERE
  CAST(Started AS DATE) >= CURRENT_DATE

----------------
Create users through SQL :

CREATE USER Arno WITH ROLE FULL_ACCESS
DROP USER Arno

----------------
Registering databases in "master" database.

For example :

SELECT
  *
FROM
  Master.DATABASES

gives a list with all databases available for the client.

----------------
Adding DEFAULT COLLATE to the CREATE DATABASE statement.

Table RDB$CHARACTER_SETS conatins already RDB$DEFAULT_COLLATE_NAME but is unused.

It's possible to manualy modify this field an the tables are indeed create with the default collate from this field, but when a backup is made and a restore is done this value is lost !!!!

----------------
COALESCE (same as ISNULL) function.
NULLIF function.
a SUBSTR function with truncates values without a exception if it's to big.

----------------
BACKUP - RESTORE facitility through SQL statements

Example :
BACKUP DATABASE dbname TO DISK "\\WS-USER\BACKUP\20020501.GBK"
RESTORE DATABASE dbname FROM DISK "\\WS-USER\BACKUP\20020501.GBK"

----------------
SCHEMA's with correspondents to some above feature requests.





Workarounds
None
Attachment
None
Comments

Craig Stuntz at 3/20/2003 8:40:20 AM -
The connection information is available from TMP$ATTACHMENTS in IB 7.

The other features should really be in separate requests (QC reports).

George Varelas at 10/16/2006 1:14:22 AM -
I use interbase 7.1 and i can' t found isc4.gdb! How can transfer all users to an other interbase server?

Server Response from: ETNACODE01