Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: I thought I understood rights

    As a user, I can run this query:

    select * from v$session;

    But I can't create the view:

    create or replace view test_view
    as
    select * from v$session;


    Can someone describe this functionality in terms of why it enhances Oracle's security? This is one rule I keep forgetting, and I think it's because I don't see the reason for it.

    Thanks,
    Chuck

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

    Wink

    You have grant direct access to the view:
    Code:
    grant select on V_$session to theuser;
    create or replace view test_view
    as select * from sys.v_$session;

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

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    THanks. I know that you need direct access to the view, but I guess I'm wondering why the fact that I have the SELECT_CATALOG_ROLE doesn't allow me to build views based on those system views.

    Is it because it invalidates the 'with grant option', seeing as I could create a view for v$session and grant select on that to someone else w/out the DBA's permission?

    thanks
    Chuck

Posting Permissions

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