Subject Re: [firebird-support] Rights needed for App with Firebird?
Author Helen Borrie
At 02:13 AM 26/09/2004 +0000, you wrote:
>I have an app running on Windows XP with a Firebird 1.5.1 Superserver
>database. When I log in as the administrator the app runs. When I'm
>logged in as someone other than an administrator the app can't seem to
>communicate with the database.
>The server is located on the same mahcine with the application. What
>rights must be available for the applicaiton to run?

To access the server, the user must be present in the security database.

To access anything in a database, the user must have SQL privileges granted
by SYSDBA or by the owners of the specified objects or by other users that
have been granted the right to grant privileges.

Tip: A package of privileges can be granted to a role. Then, when that
role is granted to a user, the user gets the privileges that are accorded
to the role. Some privileges on some types of objects can be granted to
the nominal user PUBLIC.