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
no permission for SELECT access to TABLE PLG$SRP in newer snapshot [CORE5841] #6102
Comments
Commented by: @AlexPeshkoff Could not reproduce (on a fresh B3_0_Release build): First of all create some user: ./isql -user sysdba -z employee Now I start firebird server and try with it: ./isql -user a12 -pas a12 -z localhost:employee SEC$USER_NAME GID UID Probably I'm missing something but to fix a bug we need a way to reproduce. |
Commented by: @livius2 i got this error also for SELECT ------------------------------------------------------ SQL Message : -901 Engine Code : 336723996 ------------------------------------------------------ by isql ------------------------------------------------------ SEC$USER_NAMEStatement failed, SQLSTATE = 28000 ------------------------------------------------------------------------------------------ more details about settings if i revert fb to previous WI-V3.0.4.32954 Firebird 3.0 with same database it is working ok |
Commented by: @livius2 from Firebird.conf |
Commented by: @livius2 I have tested this with newly created databse (ODS12.2) |
Commented by: @AlexPeshkoff Karol, I do not want to say that there is no issue - moreover, there were some commits related with access checks, i.e. I expect that there can be an issue. But currently I can't reproduce it. Can you attach here problematic security database? I'm almost sure that the problem is not with target db but with security one. |
Commented by: @livius2 I can not, it contain reall users and passwords :( |
Commented by: @AlexPeshkoff I.e. you were testing not with new fresh security database? |
Commented by: @livius2 With fresh security database it work ok |
Modified by: @livius2Attachment: CORE5841.png [ 13257 ] |
Commented by: @AlexPeshkoff This can't affect SRP plugin - this is legacy plugin data. BTW, at what side is your old database? :) |
Commented by: @AlexPeshkoff Sorry, but looks like I can't add something else w/o problematic DB. |
Commented by: @livius2 i have attached backup of cleared security database and compressed database itself SYSDBA password 'sysdba' P.S. what do you mean "BTW, at what side is your old database? :) " |
Commented by: @AlexPeshkoff I've meant left/right sides of .png |
Commented by: @livius2 Ach :) |
Commented by: @AlexPeshkoff Reproduced |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @AlexPeshkoff |
Commented by: @AlexPeshkoff Bug caused by changes in CORE5801 The simplest way to reproduce: isql -user KBIENIASZEWSKI sec_cleared.FDB Will show access error which is invalid here. |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] => Dmitriy Starodubov [ dmitriy starodubov ] |
Commented by: @livius2 I see it is now merged. I suppose ticket can be closed as fixed. |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Beta 1 [ 10750 ] Fix Version: 3.0.4 [ 10863 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: Waiting for reply on letter 25.09.2018 12:39 (dimitr, alex) |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred => Done successfully Test Details: Waiting for reply on letter 25.09.2018 12:39 (dimitr, alex) => |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @livius2
Assigned to: @dmitry-starodubov
Is related to CORE5801
Attachments:
CORE5841.png
sec_cleared.fbk
sec_cleared.7z
Something was broken recently.
Below sql is working under
WI-V3.0.4.32954 Firebird 3.0
but cause an error under
WI-V3.0.4.32972 Firebird 3.0
and current snapshot
WI-V3.0.4.32985 Firebird 3.0
------------------------------------------------------------------------------
find/display record error
no permission for SELECT access to TABLE PLG$SRP.
------------------------------------------------------------------------------
SELECT
U.SEC$USER_NAME
, (SELECT UA.SEC$VALUE FROM SEC$USER_ATTRIBUTES UA WHERE UA.SEC$USER_NAME=U.SEC$USER_NAME AND UA.SEC$KEY='DYR_ID') AS GID
, (SELECT UA.SEC$VALUE FROM SEC$USER_ATTRIBUTES UA WHERE UA.SEC$USER_NAME=U.SEC$USER_NAME AND UA.SEC$KEY='PRAC_ID') AS UID
FROM
SEC$USERS U
WHERE
U.SEC$USER_NAME=CURRENT_USER
-----------------------------------------------------------------------------
this core can be releated to CORE5827
For me, this is a blocking issue.
Commits: 50cd232 0c275c1 9d01fb9
The text was updated successfully, but these errors were encountered: