Insufficient privilege in the oracle
I have two schemas called master and transaction.
The main table is called - BCC_TM_CITY
In a transaction, one procedure is called PR_GETCITIES
.
This procedure table is BCC_TM_CITY
used like this
select * from master.BCC_TM_CITY;
My problem is that I recently dropped the table and added it to master again. After that, in the procedure, the PR_GETCITIES
table referencing table ( BCC_TM_CITY
) receives an error (Insufficient privilege). Now I want to know how to grant privileges to this table in SQL developer and want to resolve this error.
Please help me to solve this problem.
source to share
For a user, you need to GRANT the rights the user needs.
For example, if you want to grant SELECT, INSERT, UPDATE, and DELETE privileges , you must run the following GRANT statement:
GRANT SELECT, INSERT, UPDATE, DELETE ON BCC_TM_CITY TO master;
If you only want to grant SELECT access on a table, but for all users, you can grant privileges to a public keyword. For example:
GRANT SELECT ON BCC_TM_CITY TO public;
More examples and usage here .
source to share