Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    TX
    Posts
    4

    Unanswered: grant / revoke confusion

    This may be a simple question for you all - I am a newbie.

    Oracle 8.1.7 - platform Solaris 8.


    Window #1
    I do a sqlplus john/john ;
    SQL> show user
    USER is "JOHN"
    SQL> desc dba_users ;
    ERROR:
    ORA-04043: object SYS.DBA_USERS does not exist
    SQL> desc all_users ;
    this shows me all the users.
    next
    SQL> connect internal
    SQL> desc dba_users ;
    Now this works fine ...
    Why all_users are working w/o connecting to the internal while dba_users need connection to the internal ?. What does this connect internal does ?.

    thanks - I try to learn a lot from the Forum - any help will be appreciated.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Do the following in SQL*Plus
    CONNECT INTERNAL
    GRANT SELECT ON DBA_USERS TO JOHN;
    CONNECT JOHN/JOHN
    DESC SYS.DBA_USERS
    SELECT * FROM SYS.DBA_USERS;

    "connect internal" logs you into the database as user SYS.
    Since SYS owns DBA_USERS is has total (100%) access to it.
    Until SYS grants select access to JOHN for DBA_USERS;
    JOHN is prohibited from using it.

    I STRONGLY suggest you go to
    http://tahiti.oracle.com
    and then read the FINE manual on Oracle Concepts!

Posting Permissions

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