Subject Re: [firebird-support] Re: FB 2.0: What is the SQL to allow users to change their password?
Author Ivan Prenosil
> the services API will return users from the view,... so logged in as
> MYDBOWNER, the security service will return all users if the mods above are
> applied (default distro will only return yourself unless you're SYSDBA). The
> mods above a very difficult to apply now that direct access is vorboden...
> you have to stop the server, copy the security2.fdb, start server, make
> changes, stop server, copy back, start server again...

When I "invented" using view for the purpose of hiding users in security
database I did not do it just for fun, but because it was strongly demanded
feature by many users. But one can never please everybody :)

Ivan
http://www.volny.cz/iprenosil/interbase/