Hello All,
I have two schema called mater and transaction.
In master one table called - BCC_TM_CITY
In transaction one procedure called PR_GETCITIES.
In this procedure table BCC_TM_CITY used like this
select * from mater.BCC_TM_CITY;
my problem is, recently I dropped the table and added again in master. After that, in PR_GETCITIES procedure, the place referring table (BCC_TM_CITY) am getting error ( Insufficient privilege ). Now I want to know how to give privilege to this table in SQL developer and want to solve this error.
Please any help me to solve this problem.
Thanks in advance