sasikrishnasamy 0 Newbie Poster

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