Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HELP grant permission not working

627040Mar 11 2008 — edited Mar 12 2008
I have created a new user e.g. johnsmith like so

create user johnsmith profile default identified by johnsmith
default tablespace users
temporary tablespace temp
account unlock;
grant connect to johnsmith;
GRANT CREATE SESSION to johnsmith;
grant select on project to johnsmith;
grant select on v_emp_proj to johnsmith;
create synonym project for johnsmith.v_emp_proj;

first of all creating the synonym fails saying name used by existing object but ive tried to drop the synonym and it does not exist!!

then logging in as johnsmith and selecting * from project says table does not exist???

any ideas anyone? thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2008
Added on Mar 11 2008
21 comments
2,934 views