SHOW GRANTS does not display info about exceptions which were granted to user
-----------------------------------------------------------------------------
Key: CORE-4839
URL: http://tracker.firebirdsql.org/browse/CORE-4839
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0 Beta 2
Reporter: Pavel Zotov
connect 'localhost/3333:e30' user 'SYSDBA' password 'masterke';
create or alter user u1 password '1';
recreate exception exc_foo 'Houston we have a problem: next sequence value is
@1';
recreate sequence gen_bar start with 9223372036854775807 increment by
2147483647;
commit;
grant usage on exception exc_foo to u1; ----------------------- [ 1 ]
grant usage on sequence gen_bar to u1;
commit;
Output not containing info about possible usage of exception 'exc_foo' which
was set in [ 1 ]:
===
/* Grant permissions for this database */
GRANT USAGE ON SEQUENCE GEN_BAR TO USER U1
===
PS. User `u1`, of course, CAN use both exception & sequence:
connect 'localhost/3333:e30' user u1 password '1';
show exception exc_foo;
show sequence gen_bar;
set term ^;
execute block as
begin
exception exc_foo using (next value for gen_bar);
end
^ set term ;^
commit;
Output:
===
Exception Name Used by, Type
=============================== =============================================
EXC_FOO
Msg: Houston we have a problem: next sequence value is @1
Generator GEN_BAR, current value: 9223372036854775807, initial value:
9223372036854775807, increment: 2147483647
Statement failed, SQLSTATE = HY000
exception 6
-EXC_FOO
-Houston we have a problem: next sequence value is -9223372034707292162
===
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
