Hi guys,
New to this forum - hoping you can help out !
Can stored procedures that are stored in one schema access other tables in another schema !
Thanks
Parampreet
Printable View
Hi guys,
New to this forum - hoping you can help out !
Can stored procedures that are stored in one schema access other tables in another schema !
Thanks
Parampreet
Hi,
Yes they can - but the owner of the table must grant the required privleges to the owner of the other package/procedure.
You can then reference the table as.
Hi,
Yes they can - but the owner of the table must grant the required privleges to the owner of the other package/procedure.
You can then reference the table as owner.object
Regards
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
Maybe some text missed in the answer of Jovery
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.