Truly sorry :-(.
I had my clock set backwise, so that's why my email has date in past
(2004-06-11). Apologise and please look for my problem described below .

Boguslaw

> Hello,
>
> I've created a lot of tables,stored procedures,triggers as user
> 'DBA'.After that I tried to grant execute privilege on a one complex
> procedure to user TEST who has no other rights to tables and triggers.
> Unexpectedly error occur about no permission for read/select access for
> one table. This table is included in some tests in my procedure.
> I thought that all objects with the same owner has rights for access each
> other, even if other user is using it ?
> So, must I grant privileges for all tables mentioned in complex
> computation/tests in my procedure ?
>
> Can You explain if references privilege is required even when foreign
> keys
> are created previously or only for creating them ?
>

--
Best Regards
Bogusław Brandys