Re: [Firebird-devel] DDL permissions

2014-07-14 Thread Simonov Denis
Roman Simakov roman.sima...@red-soft.biz wrote Fri, 04 Jul 2014 18:23:38 +0400: Hello! I'd like to present a patch for firebird trunk which implements http://tracker.firebirdsql.org/browse/CORE-735 like Red Database does. Patch was discussed with Dmitry Yemanov, Alex Peshkoff and Vlad

[Firebird-devel] [FB-Tracker] Created: (CORE-4493) Index not found for RECREATE TRIGGER

2014-07-14 Thread Treeve Jelbert (JIRA)
Index not found for RECREATE TRIGGER Key: CORE-4493 URL: http://tracker.firebirdsql.org/browse/CORE-4493 Project: Firebird Core Issue Type: Bug Components: Engine Environment:

Re: [Firebird-devel] DDL permissions

2014-07-14 Thread Roman Simakov
2014-07-14 10:18 GMT+04:00 Simonov Denis sim-m...@list.ru: I think it is more correct to describe it as Agreed. -- Roman Simakov -- Want fast and easy access to all the code in your enterprise? Index and search up to

Re: [Firebird-devel] op_insert implementation removed in FB 3?

2014-07-14 Thread Alex Peshkoff
On 07/12/14 23:19, Mark Rotteveel wrote: On 12-7-2014 20:49, Adriano dos Santos Fernandes wrote: Em 12-07-2014 15:40, Mark Rotteveel escreveu: On 12-7-2014 20:36, Dmitry Yemanov wrote: 12.07.2014 21:22, Mark Rotteveel wrote: Was this functionality always broken, or has this been forgotten in

Re: [Firebird-devel] DDL permissions

2014-07-14 Thread Dalton Calford
It would be nice if there was an option for visibility ie GRANT VISIBLE FOR OBJECT TYPE OBJECT TO [USER|ROLE] user/role name [with grant option]; REVOKE VISIBLE FOR OBJECT TYPE OBJECT FROM [USER|ROLE] user/role name; With a default of all things being visible to maintain backwards

Re: [Firebird-devel] DDL permissions

2014-07-14 Thread Roman Simakov
2014-07-14 16:22 GMT+04:00 Dalton Calford dalton.calf...@gmail.com: It would be nice if there was an option for visibility ie GRANT VISIBLE FOR OBJECT TYPE OBJECT TO [USER|ROLE] user/role name [with grant option]; REVOKE VISIBLE FOR OBJECT TYPE OBJECT FROM [USER|ROLE] user/role name; With

Re: [Firebird-devel] DDL permissions

2014-07-14 Thread Dalton Calford
Hi Roman, On 14 July 2014 08:37, Roman Simakov roman.sima...@gmail.com wrote: I do not think that separate operators for these are good. It can lead to inconsistence like user has permissions on object but cannot see it. Actually, that is preferred. For developers and power users, we can

[Firebird-devel] Problems with the Firebird 3 API

2014-07-14 Thread Tony Whyman
Yesterday I posted an appeal for help with suggestions on using the new Firebird 3 API from a Free Pascal program, mainly to see if I had missed something in my analysis of the new interface. I did get one pointer to UIB. However, that did nothing more than confirm my suspicions that there are

Re: [Firebird-devel] Problems with the Firebird 3 API

2014-07-14 Thread Reinier Olislagers
On 14/07/2014 15:29, Tony Whyman wrote: Yesterday I posted an appeal for help with suggestions on using the new Firebird 3 API from a Free Pascal program, mainly to see if I had missed something in my analysis of the new interface. I did get one pointer to UIB. However, that did nothing more

Re: [Firebird-devel] Problems with the Firebird 3 API

2014-07-14 Thread Adriano dos Santos Fernandes
The ABI compatibility (including C, Delphi [but not sure about FPC] and C++ in HP-UX) was tested a number of times, IIRC by Nikolay, Vlad, me and Alex. But unfortunately, I think we did the thing wrongly. Till now I don't know what's the better way to work with status vector. Who should

Re: [Firebird-devel] Problems with the Firebird 3 API

2014-07-14 Thread Dimitry Sibiryakov
14.07.2014 17:19, Adriano dos Santos Fernandes wrote: But unfortunately, I think we did the thing wrongly. It is not too late yet to withdraw the announcement about new official API and win some time to rethink these things. -- WBR, SD.

Re: [Firebird-devel] op_insert implementation removed in FB 3?

2014-07-14 Thread Mark Rotteveel
On 14-7-2014 14:01, Alex Peshkoff wrote: Mark, unfortunately that was really only for putting data into the blob. Comments lie sometimes. Thanks, looking at the Firebird 1.0 code, it looks like originally putting data in a blob was 'also' a cursor operation; except in this case they didn't

Re: [Firebird-devel] Problems with the Firebird 3 API

2014-07-14 Thread Carlos H. Cantu
DS 14.07.2014 17:19, Adriano dos Santos Fernandes wrote: But unfortunately, I think we did the thing wrongly. DSIt is not too late yet to withdraw the announcement about new official API and win some DS time to rethink these things. Sorry if I'm mistaken, but afaiu, withdrawing it would

Re: [Firebird-devel] Problems with the Firebird 3 API

2014-07-14 Thread Dimitry Sibiryakov
14.07.2014 19:56, Carlos H. Cantu wrote: Sorry if I'm mistaken, but afaiu, withdrawing it would imply to not have a way to create dbCrypt plugins in FB 3.0. If so, I think this is not an option, since the (crypt) feature is already announced and very expected by a lot of people. It is easy