At 09:58 PM 15/04/2008, you wrote:

>Good Morning
>
>Now that I have this database users automatically creating the
>application must give permission to all tables (reading, writing). Is
>there any way to give permission to this unrestricted users in the database?

This is not an IBO issue. The owner of the database or SYSDBA should create a role in the database and grant all the needed permissions to that role.

Then, when a new user is added, Owner or SYSDBA just needs to grant that role to the user, e.g.

GRANT ROLE LEGALUSER TO NewUser

Just use an IB_DSQL for this.

Note, the users will need to supply the role as part of the login.

Helen