Re: [Firebird-devel] [Spam] Re: revoke all on all

2015-09-29 Thread Claudio Valderrama C.
> -Original Message- > From: Alex Peshkoff [mailto:peshk...@mail.ru] > Sent: Martes, 29 de Septiembre de 2015 8:01 > So what should be better done: > 1. Keep it as is > 2. Add an option to revoke granted by ABC rights too Is there anything in the SQL standard describing such situation? If

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Paul Vinkenoog
Alex Peshkoff wrote: > On 09/29/2015 03:23 PM, Dimitry Sibiryakov wrote: > > 29.09.2015 13:21, Paul Vinkenoog wrote: > >> So a CASCADE option would be a welcome addition for such cases. > > Another question: how many levels should this cascade go? > > > Unlimited, and about it will take care e

[Firebird-devel] [FB-Tracker] Created: (CORE-4948) ISQL: add warning / error message when script contains several 'IN' commands without delimiter (semicolon) between them

2015-09-29 Thread Pavel Zotov (JIRA)
ISQL: add warning / error message when script contains several 'IN' commands without delimiter (semicolon) between them --- Key: CORE-4948 URL: htt

[Firebird-devel] [FB-Tracker] Created: (CORE-4947) Compound ALTER TABLE statement with ADD and DROP the same check constraint fails

2015-09-29 Thread Adriano dos Santos Fernandes (JIRA)
Compound ALTER TABLE statement with ADD and DROP the same check constraint fails Key: CORE-4947 URL: http://tracker.firebirdsql.org/browse/CORE-4947 Project: Firebird Cor

Re: [Firebird-devel] Firebird 3 Installation

2015-09-29 Thread Alex Peshkoff
On 09/29/2015 04:28 PM, marco andreolli wrote: > Unsuccessful execution caused by a system error that precludes successful > execution of subsequent statements. > Your user name and password are not defined. Ask Your database > administrator to set up a Firebird login. > Install Incomplete, please

Re: [Firebird-devel] Firebird 3 Installation

2015-09-29 Thread marco andreolli
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements. Your user name and password are not defined. Ask Your database administrator to set up a Firebird login. Install Incomplete, please read the Compatibility chapter an the release notes for t

Re: [Firebird-devel] Firebird 3 Installation

2015-09-29 Thread Alex Peshkoff
On 09/29/2015 04:06 PM, marco andreolli wrote: > Yes sorry, obviously I change both, now I have: > AuthServer = Srp, Legacy_Auth , Win_Sspi > AuthServer = Srp, Legacy_Auth , Win_Sspi > And what is the result? (I need full error messages if some present). -

Re: [Firebird-devel] Firebird 3 Installation

2015-09-29 Thread marco andreolli
AuthServer = Srp, Legacy_Auth , Win_Sspi AuthClient = Srp, Legacy_Auth , Win_Ssp 2015-09-29 15:06 GMT+02:00 marco andreolli : > Yes sorry, obviously I change both, now I have: > AuthServer = Srp, Legacy_Auth , Win_Sspi > AuthServer = Srp, Legacy_Auth , Win_Sspi > > > 2015-09-29 14:57 GMT+02:

Re: [Firebird-devel] Firebird 3 Installation

2015-09-29 Thread marco andreolli
Yes sorry, obviously I change both, now I have: AuthServer = Srp, Legacy_Auth , Win_Sspi AuthServer = Srp, Legacy_Auth , Win_Sspi 2015-09-29 14:57 GMT+02:00 Alex Peshkoff : > On 09/29/2015 03:46 PM, marco andreolli wrote: > > I would like connect with old SYSDBA user, > > OK > > > I try to conne

Re: [Firebird-devel] Firebird 3 Installation

2015-09-29 Thread Alex Peshkoff
On 09/29/2015 03:46 PM, marco andreolli wrote: > I would like connect with old SYSDBA user, OK > I try to connect with IBExpert > and new client library. OK > I change AuthServer parameter but with no result Why do you not read what I answer to you? I've wrote 'change _both_ Auth' parameters,

Re: [Firebird-devel] Firebird 3 Installation

2015-09-29 Thread marco andreolli
I would like connect with old SYSDBA user, I try to connect with IBExpert and new client library. I change AuthServer parameter but with no result 2015-09-29 12:14 GMT+02:00 Alex Peshkoff : > On 09/29/2015 12:48 PM, marco andreolli wrote: > > Hi, > > I would like try Firebied 3 for try it and tes

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Paul Vinkenoog
Dimitry Sibiryakov wrote: > 29.09.2015 13:21, Paul Vinkenoog wrote: > > So a CASCADE option would be a welcome addition for such cases. > >Another question: how many levels should this cascade go? If applied, it should be complete, otherwise it wouldn't be much use. After all, this is for t

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Alex Peshkoff
On 09/29/2015 03:23 PM, Dimitry Sibiryakov wrote: > 29.09.2015 13:21, Paul Vinkenoog wrote: >> So a CASCADE option would be a welcome addition for such cases. > Another question: how many levels should this cascade go? > Unlimited, and about it will take care existing code - like it already d

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Dimitry Sibiryakov
29.09.2015 13:21, Paul Vinkenoog wrote: > So a CASCADE option would be a welcome addition for such cases. Another question: how many levels should this cascade go? -- WBR, SD. -- Firebird-Devel mailing list, web i

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Simonov Denis
Alex Peshkoff wrote Tue, 29 Sep 2015 14:01:21 +0300: > > OK, I agree with such argument. > So what should be better done: > 1. Keep it as is > 2. Add an option to revoke granted by ABC rights too > ? > > -- > Firebird-De

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Paul Vinkenoog
Alex Peshkoff wrote: > create table t (f int); > grant select on t to public granted by abc; > revoke all on all from abc; > > Currently privileges, granted by user ABC, remain as is after executing > mentioned revoke operator. This looks like a bug for me, but befor

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Roman Simakov
2015-09-29 13:38 GMT+03:00 Wols Lists : > Nothing specific to Firebird, but if ABC is a supervisor who has left > the company, do you really want to mess up all the people who used to > work for him? > > Or, rather more seriously, if ABC was the DBA, you can't leave him > there, it's a massive secu

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Alex Peshkoff
On 09/29/2015 01:38 PM, Wols Lists wrote: > On 29/09/15 11:20, Alex Peshkoff wrote: >> On 09/29/2015 01:11 PM, Paul Vinkenoog wrote: >>> Alex Peshkoff wrote: >>> Please look at this trivial sample. create table t (f int); grant select on t to public granted by abc; revoke a

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Wols Lists
On 29/09/15 11:20, Alex Peshkoff wrote: > On 09/29/2015 01:11 PM, Paul Vinkenoog wrote: >> Alex Peshkoff wrote: >> >>> Please look at this trivial sample. >>> >>> create table t (f int); >>> grant select on t to public granted by abc; >>> revoke all on all from abc; >>> >>> Currently privileges, gr

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Alex Peshkoff
On 09/29/2015 01:11 PM, Paul Vinkenoog wrote: > Alex Peshkoff wrote: > >> Please look at this trivial sample. >> >> create table t (f int); >> grant select on t to public granted by abc; >> revoke all on all from abc; >> >> Currently privileges, granted by user ABC, remain as is after executing >>

Re: [Firebird-devel] Firebird 3 Installation

2015-09-29 Thread Alex Peshkoff
On 09/29/2015 12:48 PM, marco andreolli wrote: > Hi, > I would like try Firebied 3 for try it and test if it improve the > performance of my software. > > I download the compressed package (not the installer), and I run the server > on another > port different from the standard because i have multi

Re: [Firebird-devel] revoke all on all

2015-09-29 Thread Paul Vinkenoog
Alex Peshkoff wrote: > Please look at this trivial sample. > > create table t (f int); > grant select on t to public granted by abc; > revoke all on all from abc; > > Currently privileges, granted by user ABC, remain as is after executing > mentioned revoke operator. This looks like a bug for me,

[Firebird-devel] Firebird 3 Installation

2015-09-29 Thread marco andreolli
Hi, I would like try Firebied 3 for try it and test if it improve the performance of my software. I download the compressed package (not the installer), and I run the server on another port different from the standard because i have multiple instance of different version of firebird. But when I t

[Firebird-devel] revoke all on all

2015-09-29 Thread Alex Peshkoff
Please look at this trivial sample. create table t (f int); grant select on t to public granted by abc; revoke all on all from abc; Currently privileges, granted by user ABC, remain as is after executing mentioned revoke operator. This looks like a bug for me, but before fixing (existing SQL op