-
How to grant the select privilege ?
Hi,
I have a table emp in SCOTT schema. A view emp_v is created based on emp in BLAKE schema.
A public synonym emp_v is created based on view in BLAKE schema.
When i select the view emp_v (or rather the public synonym) from a
3 rd schema..say Mark, i get the error Table or view doesnot exsit.
Here is the steps what i have done. Can some body tell me what grant i am misssing ???
-----------------
connect internal;
create user scott identified by tiger
/
create user blake identified by blake
/
create user mark identified by mark
/
grant connect,resource to scott,blake,mark
/
connect scott/tiger;
create table emp(enum number, ename varchar2(10) )
/
grant select on emp to public with grant option
/
connect blake/blake;
create view emp_v as select * from scott.emp
/
grant select on emp_v to public with grant option
/
connect internal;
create public synonym emp_v for balke.emp_v
/
connect mark/mark;
select * from emp_v
/
i am gettting ....ERROR table or view doesn't exist
Can somebody tell me what i'm missing.....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|