Create User
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Create User

  1. #1
    Join Date
    Jun 2002
    Posts
    65
    Hi All
    I created a user ABC...and then logged in as Scott to grant select on EMP to ABC...and grant suceeded...But when ABC logged in wants to query EMP it says table doesnt exist...Y is that...i am on win2k and 9.2...Thanks in advance

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    create synonym for that table. or suffix the table name with it's owner

  3. #3
    Join Date
    Jun 2002
    Posts
    65
    Thanks for reply but if logged in as SYS and say
    grant select on scott.emp to ABC and then grant suceeded
    after that ABC should be able to query by saying
    select * from emp;
    But ABC cant he gets mssg that table doesnt exist..y u need to create synonym for that...

  4. #4
    Join Date
    May 2001
    Posts
    25

    Unhappy

    Dear Friends


    You have to run the following command if you have not created synonym.

    SQL> select * from scott.emp;


    You have to mentioned the owner name while running the query even you have granted the permission.

    Or You can create synonym with EMP name and then you can run the following command.

    SQL> select * from EMP;


    CHEERS.....

    Naresh Kakrani
    Oracle DBA
    Reliance Telecom Ltd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width