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

Thread: View creation problem

  1. #1
    Join Date
    Aug 2000
    Posts
    143
    Im tring to create to create a view based on the sys.dba_role_privs view. Whenever I try to create this view I get the following error:

    ORA-00942: table or view does not exist

    This is the view im trying to create:

    create view view_roleusers as
    select grantee "USER", granted_role "ROLE"
    from sys.dba_role_privs
    where granted_role in ('USERROLE', 'DATALOADERROLE', 'DATAMANAGERROLE', 'BROWSERUSERROLE', 'SUPERUSERROLE')

    Note the select statement works without the create view statement.

    Any ideas what may be causing this?

  2. #2
    Join Date
    Feb 2002
    Posts
    27
    Check the schema previledges on the table dba_role_privs from where u have executing this statement.

    I had created the view using ur query successfully


  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Are you sure you have the required priviledges to the underlying sys object, it may be necessary to grant privileges directly to the user attempting to create the view.

    If the privilege is assigned to a role it will not always work

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Aug 2000
    Posts
    143
    It looked like the user need "select any table" privileges. Although im suprised these did not exist by default with the dba role

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