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