Hi you can grant execute privilege on a perticular procedure to any user like this...
GRANT EXECUTE ON procedure_name TO user;
This should be given by the owner of the procedure/package who created this procedure/package.
Sandy
"Greatest Rewards come only with Greatest Commitments!"
It should be:
You can then reference the table as schema.table_name.
But keep the next points in mind:
It is a good habit that only procedures etc. in the same schema as the table can modify the table, so grants to other schema_owners can be limited to select on the table and execute on the procedures.
When you like to modify a table out of another schema,
you have to grant INSERT/UPDATE to another schema_owner.
That may cause a leak in security.