Issue Details (XML | Word | Printable)

Key: CORE-5266
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Alexander Peshkov
Reporter: Pavel Zotov
Votes: 1
Watchers: 2

If you were logged in you would be able to see more operations.
Firebird Core

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)

Created: 09/Jun/16 02:19 PM   Updated: 10/Aug/16 02:00 PM
Component/s: None
Affects Version/s: 4.0 Initial, 3.0.0
Fix Version/s: 3.0.1, 4.0 Alpha 1

QA Status: No test

 Description  « Hide
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
SQL> quit;

PS. WI-T4.0.0.238, WI-V3.0.1.32527

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov made changes - 09/Jun/16 02:26 PM
Field Original Value New Value
Assignee Alexander Peshkov [ alexpeshkoff ]
Alexander Peshkov made changes - 10/Aug/16 02:00 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0.1 [ 10730 ]
Fix Version/s 4.0 Alpha 1 [ 10731 ]
Resolution Fixed [ 1 ]