Revoke all on all from role <R> -- failed with "SQL role <R> does not exist in security database" [CORE4831] #5128
Assignees
Comments
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Beta 2 [ 10586 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @pavel-zotov
On empty database, WI-T3.0.0.31868, do:
C:\MIX\firebird\QA\fbt-repo\tmp>C:\MIX\firebird\fb30\isql localhost/3333:e30 -user SYSDBA -pas masterke
Database: localhost/3333:e30, User: SYSDBA
SQL> show role;
There are no roles in this database
SQL> commit;
SQL> create role r_20150608_20h03m;
SQL> commit;
SQL> show role;
R_20150608_20H03M
SQL> commit;
SQL> revoke all on all from role r_20150608_20h03m;
Statement failed, SQLSTATE = 28000
unsuccessful metadata update
-REVOKE failed
-SQL role R_20150608_20H03M does not exist
-in security database
SQL>
PS.
Perhaps it's related to: http://sourceforge.net/p/firebird/code/61729 ("Postfix for CORE4821: fixed segfault in REVOKE ALL ON ALL") ?
Commits: 225cca9 FirebirdSQL/fbt-repository@fcf1478
The text was updated successfully, but these errors were encountered: