| Subject | Getting a list of system users via SQL |
|---|---|
| Author | Dalton Calford |
| Post date | 2015-09-01T14:24:22Z |
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!
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?
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?