Urgent Help in Creating View..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Urgent Help in Creating 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