Subject RE: [firebird-support] Availible users as no-sysdba-user in FB 2
Author Alan McDonald
> Can I get a list of valid user names in fb 2 as no-sysdba user?
>
> I've an user, which is owner of a db but not sysdba. The question is
> how he can validate his grant statements.
>
> --
> Björn Reimer, Datenbanken und DV-Verfahren
>

not sure what you mean by validate his grant statements but for the owner to
see the list of users, you need to make some modifications to the
security2.fdb file. As distributed, the security database will only allow a
user to see himself.

GRANT SELECT ON USERS TO PUBLIC;

since the database is not accessible while the serer is online, you eed to
make copies, access it under another name, make the mods and then replace
the original.


Alan