Allow statement 'create OR ALTER user sysdba password ...' to initialize empty
securityN.fdb as 'CREATE user ...' (i.e. which is typed without "or alter"
clause)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5266
URL: http://tracker.firebirdsql.org/browse/CORE-5266
Project: Firebird Core
Issue Type: Improvement
Affects Versions: 3.0.0, 4.0 Initial
Reporter: Pavel Zotov
Priority: Minor
Chapter "Initializing the Security Database" (Firebird-3.0.0-ReleaseNotes.pdf,
pg 126) issues that for initializing of empty securityN.fdb one need to connect
to secN.fdb using local protocol and issue then 'CREATE USER SYSDBA PASSWORD
....'.
It would be nice if command 'create OR ALTER user sysdba ...' also could work
for this case.
Currently this is not so:
C:\MIX\firebird\fb40>.\isql security4.fdb
Database: security4.fdb, User: SYSDBA
SQL> create OR ALTER user sysdba password 'masterke';
Statement failed, SQLSTATE = 28000
no operation specified
-Install incomplete, please read the Compatibility chapter in the release notes
for this version
SQL> create user sysdba password 'masterke';
SQL> commit;
SQL> show users;
Users in the database
2 #SYSDBA
SQL> quit;
PS. WI-T4.0.0.238, WI-V3.0.1.32527
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
