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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.