Re: [Firebird-net-provider] FirebirdSql.Data.Services demands SYSDBA to list users, where RDB$ADMIN insufficient?

2017-02-24 Thread David Carr
Hi Jiri, I also posted on the Firebird Yahoo group, and received an informative response that from what the person looked at, they wrote that it seemed that the .NET Provider does not use the ROLE when connecting. When I dig into the .NET Provider source, specifically the

[Firebird-net-provider] FirebirdSql.Data.Services demands SYSDBA to list users, where RDB$ADMIN insufficient?

2017-02-23 Thread David Carr
When I am trying to use some of the FirebirdSql.Data.Services API (v5.6) against a Firebird v2.5.6 database, such as; - FirebirdSql.Data.Services.FbServerProperties.GetDatabasesInfo() - FirebirdSql.Data.Services.FbSecurity.GetUsersDbPath() I get the error: "Service isc_info_svc_svr_db_info

Re: [Firebird-net-provider] FBUserData create new

2016-11-17 Thread David Carr
Is this the same for the other FbUserData fields: 1. GroupID 2. GroupName 3. UserID The rest (it First/Middle/LastName seem to work fine). If there are differences between versions, that would be worth knowing. We are running Firebird v2.5, and I am developing on VS2013 using the ADO.NET client

Re: [Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs

2016-11-09 Thread David Carr
Thanks for getting back to me. Can you or anyone please let me know what is the recommended approach in the ADO.NET provider for performing a transaction across, let's say, 2 databases (eg a single command in each)? On 5 November 2016 at 08:37, Jiří Činčura wrote: > I don't

[Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs

2016-11-04 Thread David Carr
Hi Jiri and all, We are running FB v2.5, and I am using the ADO v5.5.0 DLL to connect from my VS2013 C# project to 4 different databases. I have a little tool for user management, and to narrow the focus, one of the operations is to delete the user by: - REVOKE ALL GRANTs across all DBs - DROP