> > > 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.

Thomas is right here... By default, the _object owner_ has access to the
object :)
Which, in my case, is always the database owner :)

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."