Results 1 to 7 of 7

Thread: Synonyms

  1. #1
    Join Date
    Jul 2005
    Posts
    276

    Unanswered: Synonyms

    When i create a synonym on a particular table and give access to someone on this table in a different schema; then make some changes to the original table, like adding a new column or changing the datatype or adding a partition..; Will it reflect in the synonym or not?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool



    Synonym's are only alternate names for the same object.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jul 2005
    Posts
    276
    Thanks LKBrwn_DBA.

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool



    No problem, take it easy!
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Aug 2004
    Posts
    330
    Synonyms are easy. Try working with antonyms. They are tricky. You have to use negative logic.

  6. #6
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by urquel
    Synonyms are easy. Try working with antonyms. They are tricky. You have to use negative logic.

    What do "antonyms" have to do with Oracle DB? Or is it just a joke.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  7. #7
    Join Date
    Aug 2004
    Posts
    330
    I was joking!

Posting Permissions

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