Stored procedure isn't able to execute statement 'GRANT'
Key: CORE-6502
URL: http://tracker.firebirdsql.org/browse/CORE-6502
Project: Firebird Core
Issue Type: Bug
Affects
2021.03.04. 11:49 keltezéssel, Alex Peshkoff via Firebird-devel írta:
That are grants to system privileges. Normally they are created using
GRANT something TO SYSTEM PRIVILEGE name, but some are predefined in
database. If you use this SQL:
select distinct RDB$RELATION_NAME, T.RDB$TYPE_NAME
On 3/4/21 1:00 PM, Gabor Boros wrote:
Hi All,
In ISQL with a brand new 4.0 database:
SQL> select distinct rdb$user, rdb$user_type from rdb$user_privileges
where rdb$user not in ('SYSDBA','PUBLIC') order by rdb$user;
RDB$USER RDB$USER_TYPE
=
22 20
3
Hi All,
In ISQL with a brand new 4.0 database:
SQL> select distinct rdb$user, rdb$user_type from rdb$user_privileges
where rdb$user not in ('SYSDBA','PUBLIC') order by rdb$user;
RDB$USERRDB$USER_TYPE
=
22 20
3 20
4
On 3/4/21 11:47 AM, Jiří Činčura wrote:
Hi *,
does fb_cancel_raise cancel also currently running prepare
(op_prepare_statement)?
Yes, it should. It's able to cancel any operation except attach/detach.
But must say never used to test it explicitly.
Firebird-Devel mailing list, web
Hi *,
does fb_cancel_raise cancel also currently running prepare
(op_prepare_statement)?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel