User management

[Martin Ågren]

Hi,

Just to be sure, there is no way to (legacy auth)

• List users 
• Find out if user has "Grant admin role" in security database

via the provider, right? These are surfaced solely in the gsec cli? 

TIA,

/Martin

[Jiří Činčura]

> • List users

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/src/FirebirdSql.Data.FirebirdClient/Services/FbSecurity.cs#L298

> • Find out if user has "Grant admin role" in security database

I'm not aware of a way to do it through Service API. If you're at least on FB3, you can use `SEC$USERS`.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

[martin agren]

No, 2.5.9 I'm afraid.
Many thanks, Jiri! You do great work.

/M

-----Ursprungligt meddelande-----
Från: firebird-n...@googlegroups.com <firebird-n...@googlegroups.com> För Jirí Cincura
Skickat: den 13 oktober 2023 10:32
Till: 'Mr. John' via firebird-net-provider <firebird-n...@googlegroups.com>
Ämne: Re: [firebird-net-provider] User management

--
You received this message because you are subscribed to the Google Groups "firebird-net-provider" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-net-pro...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/firebird-net-provider/a61aa89d-7127-4ae6-a65c-cfd8ec4d4f0a%40app.fastmail.com.

[Mark Rotteveel]

On 13-10-2023 10:31, Jiří Činčura wrote:
>> • List users
>
> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/src/FirebirdSql.Data.FirebirdClient/Services/FbSecurity.cs#L298
>
>> • Find out if user has "Grant admin role" in security database
>
> I'm not aware of a way to do it through Service API. If you're at least on FB3, you can use `SEC$USERS`.

It is available through the services API with item isc_spb_sec_admin
IIRC, but just like gsec, the services API for user management is
deprecated.

Mark
--
Mark Rotteveel