[Firebird-devel] [FB-Tracker] Created: (CORE-6502) Stored procedure isn't able to execute statement 'GRANT'

2021-03-04 Thread Roman Simakov (JIRA)
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

Re: [Firebird-devel] RDB$USER_PRIVILEGES of 4.0

2021-03-04 Thread Gabor Boros
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

Re: [Firebird-devel] RDB$USER_PRIVILEGES of 4.0

2021-03-04 Thread Alex Peshkoff via Firebird-devel
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  

[Firebird-devel] RDB$USER_PRIVILEGES of 4.0

2021-03-04 Thread Gabor Boros
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

Re: [Firebird-devel] fb_cancel_raise for prepare

2021-03-04 Thread Alex Peshkoff via Firebird-devel
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

[Firebird-devel] fb_cancel_raise for prepare

2021-03-04 Thread Jiří Činčura
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