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

Oh, my mistake - erro occur when procedure is executed by user TEST , not
when privilege granted of course :-)

> 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