DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Feb 2001


    Can any one please let me know why I can't view, even I have the Dba Priviliges, RECOVERY_CATALOG_OWNER Priviliges and Imp_Full_Database

    and all of thses Roles have Create any View.

    Here is the Query.
    create or replace view tbv
    as select TABLESPACE_NAME,
    sum( BYTES) allocated_space
    from dba_data_files
    group by TABLESPACE_NAME;

    Gives that Object Does not exits
    But if I Issue this select statement, that works fine.

    Thanks in Advance.

  2. #2
    You can't create "fixed" object with privileges granted by a role.
    That's because roles can be enabled/disabled and if you could create a fixed object that feature would be meaninless.
    So, if you want the view, connect as sys and grant yourself privileges on the v_$ views
    I hope I'm clear
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Feb 2001
    Thanks Ramon,

    What do you mean give the Priviliges on V$... Is there some specific View that I need to have privilege on to create any other view on those.

    Thanks ..

  4. #4
    Never mind.
    I was confused because long time ago I was able to create a procedure select v$session only when I granted select on v_$session.
    Anyway, enter as sys and grant to the user select on dba_data_files, I tested it and it worked.
    Ramon Caballero, DBA, rcaballe@yahoo.com

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.