How to grant the select privilege ? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: How to grant the select privilege ?

  1. #11
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Code:
    SQL> create synonym  xx for th.ddf;
    
    Synonym created.
    
    SQL> select * from xx;
    select * from xx
                  *
    ERROR at line 1:
    ORA-00980: synonym translation is no longer valid
    Abhay is correct.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  2. #12
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    ok thats true, but if you to desc xx you get a different message 'object th.dff does not exist'

    Which is still actually different than ORA-00942 so I gues the OP either had the user there or gave us the wrong error message as Abhay said
    Last edited by davey23uk; 12-09-2003 at 08:22 AM.

  3. #13
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by davey23uk
    not true ...

    Code:
    [oracle@cim4 oracle]$ sqlplus "/ as sysdba"
     
    SQL*Plus: Release 9.2.0.1.0 - Production on Tue Dec 9 11:48:49 2003
     
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
     
     
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning option
    JServer Release 9.2.0.1.0 - Production
     
    SQL> create public synonym emp_v for blah.emp;
     
    Synonym created.
     
    SQL> select username from dba_users;
     
    USERNAME
    ------------------------------
    SYS
    SYSTEM
    OUTLN
    MZADMIN
    DBSNMP
    Wass not true...& i have no clue why you have posted the part of the code?

    Did i ever tell, its not possible to create a synonym for NON existent object??

    Well, i said the error he is getting is not what he shud have GOT, if he is getting that error then there should be some user by the TPYO and table/view by that name and no privs for user querying for that synonym...

    Is ther any thing where i am not being logical in my approch??

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #14
    Join Date
    Sep 2002
    Posts
    376
    Originally posted by Thomasps
    Code:
    SQL> create synonym  xx for th.ddf;
    
    Synonym created.
    
    SQL> select * from xx;
    select * from xx
                  *
    ERROR at line 1:
    ORA-00980: synonym translation is no longer valid
    Abhay is correct.


    I Dont had any user by name BALKE....

    You get "ORA-00942: table or view does not exist"
    when u create a PUBLIC synonym

    create public synonym xxx for th.ddf

    SELECT * FROM XXX

    ORA-00942: table or view does not exist

  5. #15
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Wass not true...& i have no clue why you have posted the part of the code?

    Did i ever tell, its not possible to create a synonym for NON existent object??

    Well, i said the error he is getting is not what he shud have GOT, if he is getting that error then there should be some user by the TPYO and table/view by that name and no privs for user querying for that synonym...

    Is ther any thing where i am not being logical in my approch??

    Abhay.
    thats why I corrected myself after - i apologise

  6. #16
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by bang_dba
    I Dont had any user by name BALKE....

    You get "ORA-00942: table or view does not exist"
    when u create a PUBLIC synonym

    create public synonym xxx for th.ddf

    SELECT * FROM XXX

    ORA-00942: table or view does not exist
    Yes indeed on 8.x it throws this misleading error. But 9.x no probs, the error is relevent.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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