Hi,
Tried with Windows 32bit and embedded engine, snapshot 3.0.0.31444, got
error with SEC$USERS.
Databases.conf:
MYDB = C:\Databases\MYDB.FDB
{
SecurityDatabase = MYDB
}
gsec -user SYSDBA -add MYADMIN -pw xxx -admin yes
isql -user MYADMIN
CREATE DATABASE "MYDB" PAGE_SIZE 4096;
isql -user MYADMIN MYDB
Database: MYDB, User: MYADMIN
SQL> SHOW USERS;
Users in the database
# MYADMIN
SQL> SELECT DISTINCT RDB$OWNER_NAME AS DATABASE_OWNER
CON> FROM RDB$RELATIONS
CON> WHERE (RDB$SYSTEM_FLAG = 1);
DATABASE_OWNER
===============================
MYADMIN
SQL> SELECT * FROM SEC$USERS;
Statement failed, SQLSTATE = 28000
find/display record error
-Install incomplete, please read chapter "Initializing security
database" in Quick Start Guide
Gabor
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
