I create a private synonym in the Scott:
CREATE SYNONYM s_dept
FOR dept.
Then
Grant select on dept to sys.
And then as a sys landing:
Select * from s_dept;
There is no
prompt table or viewWhy can't access s_dept excuse me?

CodePudding user response:

Grant select on s_dept to sys.
It also performs a try

CodePudding user response:

Select * from Scott. S_dept

CodePudding user response:

You are creating a private synonyms, sys no permission to use it, even if you are authorized to the base table is useless

CodePudding user response:

Create synonym in the sys
CREATE SYNONYM s_dept FOR Scott. Dept;
Or to create public synonyms
CREATE public SYNONYM s_dept FOR Scott. Dept;