--- In firebird-support@yahoogroups.com, "ktadimeti" <tadimetikeshav@...> wrote:

>
> All
> I am new to Firebird. I have tried to read up the Borrie book and google hits to solve this issue, so please bear with my ignorance.
>
> I want to create a DB owned by SYSDBA, and access it as a non-privileged user who can create objects. The Username is not recognized by ISQL, although found in GSEC. To gain access I granted RDB$ADMIN to the username. What is the normal privilege I need to merely make a connection?
>
> Thanks in advance
> MfG
> TK
>
> my steps:
> a. create a user from GSEC.
> GSEC> display
> user name uid gid admin full name
> ----------------------------------------------------------------------
> SYSDBA 0 0 Sql Server Administrator
> ABCDEF 1 0 admin xxxx yyyy DBA
> GSEC>
>
> b. create a DB as sysdba from ISQL
> CREATE DATABASE 'd:\ABCDEF\DEV\FIREBIRD\rough.fdb';
>
> c. connect ABCDEF user to new DB
> C:\>isql -user ABCDEF -password oracle;
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> connect 'd:\ABCDEF\dev\firebird\rough.fdb';
> Statement failed, SQLSTATE = 28000
> Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
> SQL> exit;

You made terrible thing ! The password is very, very bad ! Never use this evil word with Firebird, never !

:-D

Regards,
Vlad

PS Did you notice last character after evil word ? Try without it ;)