Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    76

    Unanswered: viewing user defined Synonyms

    Hi,

    I need to select all the Users Synonyms. If I use ALL_SYNONYMS, even System Defined synonyms (Synonyms defined by owner "MDSYS") are reterived. And "USER_SYNONYMS" becomes one user specific.

    Any pointers will be helpful.

    -Cheeku

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    How about adding:

    WHERE OWNER NON IN ('MDSYS',...)

Posting Permissions

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