Re: [Firebird-devel] isc_database_info and current database user

2019-03-02 Thread Dmitry Yemanov
02.03.2019 11:30, Mark Rotteveel wrote: I am just wondering if the requested feature is not already present. A quick test with isc_database_info, with SYSDBA and a normal user logged in shows: - SYSDBA connection: only SYSDBA appears to be returned. - User connection: only user name is ret

Re: [Firebird-devel] isc_database_info and current database user

2019-03-02 Thread Mark Rotteveel
On 1-3-2019 12:02, Tony Whyman wrote: I am just wondering if the requested feature is not already present. A quick test with isc_database_info, with SYSDBA and a normal user logged in shows: - SYSDBA connection: only SYSDBA appears to be returned. - User connection: only user name is returne

Re: [Firebird-devel] isc_database_info and current database user

2019-03-01 Thread Tony Whyman
I am just wondering if the requested feature is not already present. A quick test with isc_database_info, with SYSDBA and a normal user logged in shows: - SYSDBA connection: only SYSDBA appears to be returned. - User connection: only user name is returned. From the security viewpoint, only a

Re: [Firebird-devel] isc_database_info and current database user

2019-03-01 Thread Adriano dos Santos Fernandes
On 01/03/2019 07:43, Dimitry Sibiryakov wrote: > 01.03.2019 11:32, Alex Peshkoff via Firebird-devel wrote: >> But if one writes some funny plugin which generates random names in >> authentication block - definitely yes :) > >   They don't need to be random. I can imagine cases when they are a) > ti

Re: [Firebird-devel] isc_database_info and current database user

2019-03-01 Thread Dimitry Sibiryakov
01.03.2019 11:32, Alex Peshkoff via Firebird-devel wrote: But if one writes some funny plugin which generates random names in authentication block - definitely yes :) They don't need to be random. I can imagine cases when they are a) tied to a current node in a cluster because Firebird disal

Re: [Firebird-devel] isc_database_info and current database user

2019-03-01 Thread Alex Peshkoff via Firebird-devel
On 3/1/19 1:25 PM, Dimitry Sibiryakov wrote: 01.03.2019 8:59, Alex Peshkoff via Firebird-devel wrote: Mapped user name has nothing to do with connection pool.   Are you sure that there will be never a case when single client-side user name is mapped to different server-side users depending on

Re: [Firebird-devel] isc_database_info and current database user

2019-03-01 Thread Dimitry Sibiryakov
01.03.2019 8:59, Alex Peshkoff via Firebird-devel wrote: Mapped user name has nothing to do with connection pool. Are you sure that there will be never a case when single client-side user name is mapped to different server-side users depending on some conditions unknown to client? -- WB

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Alex Peshkoff via Firebird-devel
On 3/1/19 12:40 AM, Adriano dos Santos Fernandes wrote: Grouped by user name of what connection pool already is configured for: the user name to connect. Certainly. Mapped user name has nothing to do with connection pool. Why would anyone need the mapped user name instead of the already know

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Mark Rotteveel
On 2019-02-28 20:57, Adriano dos Santos Fernandes wrote: On 28/02/2019 16:54, Mark Rotteveel wrote: The same can be asked for a lot of other information items that can be obtained from isc_database_info. And the answer is invariably: because it can be useful for an application or a driver itsel

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Adriano dos Santos Fernandes
On 28/02/2019 17:09, Dimitry Sibiryakov wrote: > 28.02.2019 20:42, Adriano dos Santos Fernandes wrote: >> Then the question: for what the client would need to known the mapped >> user name? > >   The simplest example: connection pool must grouped by user name > because currently there is no way to

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Dimitry Sibiryakov
28.02.2019 20:42, Adriano dos Santos Fernandes wrote: Then the question: for what the client would need to known the mapped user name? The simplest example: connection pool must grouped by user name because currently there is no way to change current user of already established connection. (

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Adriano dos Santos Fernandes
On 28/02/2019 16:54, Mark Rotteveel wrote: > > The same can be asked for a lot of other information items that can be > obtained from isc_database_info. And the answer is invariably: because > it can be useful for an application or a driver itself to obtain that > information. > Why it could be ne

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Mark Rotteveel
On 2019-02-28 20:42, Adriano dos Santos Fernandes wrote: On 28/02/2019 16:20, Mark Rotteveel wrote: As far as I understand it, if you use the Firebird 3 mapping feature, than you can remap the login and role of any user to an entirely different user. So, as far as I know, a client no longer kn

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Adriano dos Santos Fernandes
On 28/02/2019 16:20, Mark Rotteveel wrote: > > As far as I understand it, if you use the Firebird 3 mapping feature, > than you can remap the login and role of any user to an entirely > different user. > > So, as far as I know, a client no longer knows what the actual user > is, even if it used use

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Mark Rotteveel
On 28-2-2019 13:00, Alex Peshkoff via Firebird-devel wrote: On 2/28/19 2:15 PM, Kovalenko Dmitry wrote: Can you explain - what a problem with use of SQL to get that data? Need start (and commit) implicit transaction. For me - it is not good behavior of provider. For RORC I can't say for sure

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Alex Peshkoff via Firebird-devel
On 2/28/19 2:15 PM, Kovalenko Dmitry wrote: Can you explain - what a problem with use of SQL to get that data? Need start (and commit) implicit transaction. For me - it is not good behavior of provider. For RORC I can't say for sure that this is too bad behavior. But as a minimum getInfo() r

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Kovalenko Dmitry
> Can you explain - what a problem with use of SQL to get that data? Need start (and commit) implicit transaction. For me - it is not good behavior of provider. Dmitry Kovalenko. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread liviuslivius
No, you can have e.g. windows autentication Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Alex Peshkoff via Firebird-devel
On 2/28/19 1:46 PM, Adriano dos Santos Fernandes wrote: On 28/02/2019 05:30, Kovalenko Dmitry wrote: select current_user from rdb$database Usage of similar queries is not good idea for connection provider. It is problem to added new info-tags (current_user and, may be, current_role) for isc_da

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Adriano dos Santos Fernandes
On 28/02/2019 05:30, Kovalenko Dmitry wrote: >> select current_user from rdb$database > Usage of similar queries is not good idea for connection provider. > > It is problem to added new info-tags (current_user and, may be, > current_role) for isc_database_info in FB3.0.5? > > From my side I will ad

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Kovalenko Dmitry
> select current_user from rdb$database Usage of similar queries is not good idea for connection provider. It is problem to added new info-tags (current_user and, may be, current_role) for isc_database_info in FB3.0.5? >From my side I will added the special support for these new tags into my pro

Re: [Firebird-devel] isc_database_info and current database user

2019-02-27 Thread Alex Peshkoff via Firebird-devel
On 2/27/19 12:30 PM, Kovalenko Dmitry wrote: Hello, Could anybody tell me – how I can get name of current user through isc_database_info API function? I see isc_info_user_names. But I want to get the only one name. isql is using select current_user from rdb$database Firebird-Devel mai

[Firebird-devel] isc_database_info and current database user

2019-02-27 Thread Kovalenko Dmitry
Hello, Could anybody tell me - how I can get name of current user through isc_database_info API function? I see isc_info_user_names. But I want to get the only one name. Thanks, Dmitry Kovalenko. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/li