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

2017-02-24 Thread Jiří Činčura
> if ((_csManager?.Role.Length ?? 0) != 0) > spb.Append((byte)IscCodes.isc_spb_sql_role_name, _csManager.Role); > > That being said, it doesn't seem to have an effect and even if logged in > with role RDB$ADMIN, only the given user is returned (other than if > SYSDBA). > > Thoughts? Is there any

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

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

2017-02-24 Thread Jiří Činčura
> This is different from how things work in gsec. There, enumeration of > users > IS possible by connecting via the RDB$ADMIN role; > >gsec -user MyAdm -pass admpw -role rdb$admin -display This gsec command is not connecting to remote database using services API. -- Mgr. Jiří Činčura

[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