About Oracle permission problems

I have a question to ask:
The premise:
Users of A database, B
The A user table table1

For the B user table1 access through system Fu:
create public synonym table1 for A.table1;
grant all on A.table1 to B;

The problem:
Create the stored procedure table1 B user environment, why A.table1 does not have permission to access?

Started by Humphrey at November 22, 2016 - 8:27 AM

Try synonyms of drop.

Posted by Cher at December 02, 2016 - 8:40 AM

You are empowered under the system. You want in the weighted A under

Posted by Tess at December 11, 2016 - 8:54 AM