Subject | Re: Getting a list of system users via SQL |
---|---|
Author | Dmitry Yemanov |
Post date | 2015-09-01T15:01:12Z |
01.09.2015 17:24, Dalton Calford wrote:
Dmitry
> With firebird 2.5 we received some wonderful tools that allowed us to create, update and drop users without needlessly mucking about with smacking the security database. Yea!Only in FB3, via sec$users.
>
> But, we also where locked out from reading the security database so we can no longer see who is defined in the database via sql. Boo!
>
> So, what I want to know is, is it possible to get a list of currently defined users for the system database, via sql.
>
> ie., select * from mon$security2 or some other such method?
Dmitry