Subject Re: [firebird-support] Embedded server User privileges
Author Helen Borrie
At 04:27 PM 3/02/2006, you wrote:
>Where the RDB$USER_PRIVILEGES is stored ?

It is a system table in the database. SQL privileges are always
database-specific.

>If I grant some user privileges use Firebird sever.
>Then use embedded server, can I still retrieve what user privileges
>are granted ?

See above. The server doesn't have external knowledge of the
privileges stored inside a database; it simply knows when and where
to go to find them.


>Note: in my laptop, I only put the neccessary fbembed.dll and other
>files onto it, no Firebird server installed ?

If you have fbembed.dll running then you have a server running. It
is like the full superserver, except that can only be started by your
client application, it is not subject to server-level user
authentication and it will not allow another client to connect to it
- it recognises only the client instance that started it.

./heLen