User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA. [CORE1083] #1504
Comments
|
Commented by: @AlexPeshkoff Can you try with 2.1 snapshot build? Is bug still present in it? |
|
Commented by: Chernyak Sergey (chernyak.s) Where I can download 2.1 snapshot ? |
|
Commented by: Chernyak Sergey (chernyak.s) Bug is still present in WI-T2.1.0.14818 Firebird 2.1 Alpha 1 Snapshot 20060123. |
Modified by: @dyemanovassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => In Progress [ 3 ] |
|
Commented by: @AlexPeshkoff This behavior is almost up to SQL standard - when grantor does not match current user, privilege should not be revoked. I.e. for successfull revoke all 4 - grantor, grantee, object and privilege shoud match. Certainly, SYSDBA can do all:) What's wrong now - when grantee, object and privilege do not match, this is warning condition, and when this 3 do match but grantor is wrong - this is an error. But any diagniostic is missing now inFirebird. |
|
Commented by: @AlexPeshkoff Made behavior of firebird more standard compliant concerning REVOKE. |
Modified by: @pcisarFix Version: 2.1 Beta 1 [ 10141 ] |
Modified by: @pcisarWorkflow: jira [ 11490 ] => Firebird [ 15493 ] |
|
Commented by: @pmakowski Q/A tested |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: No test => Done successfully |
Submitted by: Chernyak Sergey (chernyak.s)
Is related to CORE885
Is related to QA166
User (not SYSDBA) what have privileges with grant option on object in database, can't revoke privileges, granted by other user or SYSDBA, on that database object. Server don't raises any exception and do nothing.
Commits: f9b7195
The text was updated successfully, but these errors were encountered: