On 03/21/14 00:51, Claudio Valderrama C. wrote: > Hello, I have an empty x.fdb in FB3. I created some user "caspian". I start > firebird.exe with > -ma flags (multi + application). Now I can connect through TCP with that > user but not with sysdba: > > F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird>isql localhost:x.fdb > -user sysdba -pass masterkey > Statement failed, SQLSTATE = 28000 > Your user name and password are not defined. Ask your database administrator > to set up a Firebird login. > -attempt to fetch past the last record in a record stream > Use CONNECT or CREATE DATABASE to specify a database > > Attempt to fetch past the last record??? > > This unprivileged user "caspian" exists in the DB, I defined it with CREATE > USER: > > F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird>isql localhost:x.fdb > -user caspian -pass caspian > Database: localhost:x.fdb, User: caspian > SQL> > > What am I missing with sysdba? It's a global user, I should not need to > create it.
Under normal circumstances SYSDBA is created by installer after asking password from you or generating it automatically for silence install. We anyway used same techniques to change default password, but in case of failure when changing password had a chance to get firebird running with default password. Creating sysdba during install helps avoid such insecure cases. I do treat as a big problem running one command to add SYSDBA for people who install FB manually. ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
