Hi,
First of all, i do not have sample scripts to upload it here. However, i am just updating my problem in theoretical view. Please provide the answer with detailed explanation.
Schema Name: Global
1) User: A created a Table called Employee
2) User: A Created a Package Employee_details with procedures and Functions inside.
Now if i try access the Package:Employee details from another schema:Local - User B ,
1) Is Granting EXECUTE rights to User: B is enough to access the Packages from Local Schema?
-----------------------------------------------------------------------------------------------------------------------------------------
For example, In Schema:Global, If package:Employee_details contains 100 tables inside, User:A from Schema:Global has all rights to this 100 tables.
Now, I am executing below command from Schema: Local:
"GRANT EXECUTE on GLOBAL.EMPLOYEE_DETAILS to USER:B".
My question here is:
2) Is User:B can execute Insert/update/delete on those 100 tables alone? Or these tables only accessible when package is invoked?
Hope i explained clearly now. Feel free to ask me Friend if it is
Please explain this Access privileges between schemas for Packages in detail. I couldnt find the reason in Web:-(
Message was edited by: AJ.