Problem solved!

Here the steps:

1. Create Unix user
2. Set Ingres environment to Unix user
3. create DB user with same name than Unix user
4. create grant script with select 'grant select on
'+squeeze(table_name)+' to username'+'; commit;' from iitables where
table_owner = 'myowner' AND (table_type= 'T' OR table_type = 'V');
5. This was my major fault: execute the grant scripts in exclusiv mode
(there should be nobody working with the database, because inges needs
exclusiv rights on the tables during grant statements)
6. Stopping and starting ingres again.


Thank you all for your support.

cheers
Johannes

On 8 Feb., 16:54, Ingres Forums <info-
ing... (AT) kettleriverconsulting (DOT) com> wrote:

I don't see any reason why you have to do steps 5 and 6.
Ingres doesn't require exclusive DB access to do grants.
It just requires an exclusive lock on the table, but provided your
other users commit their transactions where the table is involved this
shouldn't be a problem.
Once the grant is commited the table is immediately accessible by the
grantee, so no reason to restart the DBMS.


--
Bodo

I am not an expert on this,
but if I tried to execute the grant script (serveral times) we got a
lot of logical locks
which could not be solved by killing the specific process number.
It seems to be a deadlock scenario.
But it is also possible that this was a result of bad software design.

I took my chance in a scheduled downtime and it works without any
problems
with exclusiv access.

Johannes