| Subject | Re: [firebird-support] Re: How can I get a list of firebird db users? |
|---|---|
| Author | Helen Borrie |
| Post date | 2012-01-11T19:06:42Z |
At 03:52 AM 12/01/2012, Ahmet Nuri D wrote:
All this gives you is a list of users (that may or may not exist) which have SQL privileges assigned to them *in that database*. The security database (where user accounts live) is not linked to user databases in any way.
./heLen
>I find one solition for thatIf it was that easy, someone would have told you about it. ;-)
>
>SELECT RDB$USER
>FROM RDB$USER_PRIVILEGES
>group by
>1
All this gives you is a list of users (that may or may not exist) which have SQL privileges assigned to them *in that database*. The security database (where user accounts live) is not linked to user databases in any way.
./heLen