Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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) [CORE5266] #5545

Closed
firebird-issue-importer opened this issue Jun 9, 2016 · 2 comments

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Jun 9, 2016

Submitted by: @pavel-zotov

Votes: 1

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

Commits: 6853447 e7d88a1

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 9, 2016

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 10, 2016

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0.1 [ 10730 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants