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

Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts [CORE5496] #5765

Closed
firebird-issue-importer opened this issue Mar 5, 2017 · 6 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented Mar 5, 2017

Submitted by: @mrotteveel

When initializing the security database for SRP, two SYSDBA accounts are created if admin option is specified explicitly.

Two sysdba accounts are created if I use (in gsec):

add sysdba -pw masterkey -admin yes

, but not if I use

add sysdba -pw masterkey

Similar if I use in ISQL:

create user sysdba password 'masterkey' grant admin role;

not if I use

create user sysdba password 'masterkey';

In the above case UserManager = Srp, Legacy_UserManager. I also tried with only UserManager = Srp.

I have also tried this in the latest 3.0.2 snapshot, it doesn't happen there.

Commits: 8d95d7c fb22a19

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 5, 2017

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 6, 2017

Commented by: @AlexPeshkoff

That's not so easy to reproduce an error in FB3 but if one does:

grant rdb$admin to sysdba granted by John;
grant rdb$admin to sysdba granted by Jane;

two records in sec$users might be seen.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 6, 2017

Modified by: @AlexPeshkoff

Version: 3.0.1 [ 10730 ]

Version: 3.0.0 [ 10740 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 6, 2017

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0.2 [ 10785 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 8, 2019

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 8, 2019

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment