Subject RE: [ib-support] firebird read only user
Author Thomas Steinmaurer
> > I can't seem to find any reference on how to add users for the database
> and give them read only access. On the user maintenance, the default is
> always full access, how can I add users and give the read only access????
> >
>
> Read/write access is controlled per database. By default, only SYSDBA or the
> database owner has full access to all database objects (tables, stored
> procedures etc).

Not entirely true, I guess ;-). The database owner do not have all permissions
on all database objects automatically. This is another reason, why a restore
with a different user changes the database owner, but *not* the owner of
all database objects.


Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com