Able to create a synonym when it should not...... ?????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Able to create a synonym when it should not...... ?????

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    Exclamation

    Hi,

    I was able to create a synonym even though the underlying schema and the object do not exist.

    Example

    SQL> create synonym WORKINPROGRESS for r2.WORKINPROGRESS;

    Synonym created.


    In the above case there is no user by the name r2 and no object called workinprogress and still oracle went ahead and created the synonym.

    Isnt that Strange.....

    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    No, a synonym is just an alias for something else. It will not be evaluated for existance or permission until it is used.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    That sounds really strange. Atleast the person creating it should realize if anything is wrong or not.


    Its just a matter of validating it while creating....
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

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