Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Textbook error? Just curious...

    My Oracle text book (Oracle9i Database Administrator, by Carol McCullough-Dieter) states that views starting with DBA require the owner, SYS, as a prefix, and gives this example:

    select table_name, column_name
    from sys.dba_tab_columns
    where rownum < 200

    ...but this code runs just fine on my machine and produces the same results:

    select table_name, column_name
    from dba_tab_columns
    where rownum < 200

    So is my text book incorrect?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >So is my text book incorrect?
    It depends upon which user is logged in & doing the SELECT
    http://download-west.oracle.com/docs...a96524/toc.htm
    Read Chap. 22 & 23
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2004
    Posts
    246
    That used to be more common in older versions of Oracle. The db create scripts would sometimes fail, or just weren't called. The dba views have public synonyms created for them, but select on the views is only granted to the DBA role, you don't need the "SYS." prefix. And if you did, you could just find the script to create the public synonyms.

Posting Permissions

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