--- In firebird-support@yahoogroups.com, "paulwesson"
<paul.wesson@g...> wrote:

>
> I'm trying to figure out how I can add a "read-only" user to the
> security.fdb using GSEC.
>
> I want to allow my users access to the database via ODBC so they can
> use other tools such as Microsoft Access, to view their information. I
> don't want them to be able to change any of the data, so I like to be
> able to somehow create a "read-only" user, i.e. with just SELECT
> privileges.
>
> I've already created a user/role in my database, but now need to get a
> user in the security database.
>
> Any one have any ideas on how I can do this?
>
> Thanks
> Paul

By DEFAULT, no user but the CREATOR and SYSDBA have any rights on any
table in your code. Just make sure you haven't issued any non-SELECT
rights to public and you should be good to go.

Then grant SELECT to PUBLIC for each of the tables in the DB.

Alternately, just grant SELECT rights for each of the tables to the
Access User.

Cheers,

Michael