Subject | RE: [firebird-support] Availible users as no-sysdba-user in FB 2 |
---|---|
Author | Alan McDonald |
Post date | 2007-10-09T09:58:32Z |
> Can I get a list of valid user names in fb 2 as no-sysdba user?not sure what you mean by validate his grant statements but for the owner to
>
> 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
>
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