Hi,

> Hi, I recently installed Firebird 1.0 for windows from www.ibphoenix.com.
>
> 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). To give a user access - select, update, delete etc - you
need to GRANT him access by doing a GRANT statement. Several tools have a
nice UI to do this - you might want to give Firebird Workbench
www.upscene.com ) a try to do this.

For more information on SQL grants, you might want to read the IB6
beta-documentation - see www.ibphoenix.com download section "InterBase".

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_interbase_download#Do
cs



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