Views in Query Analyzer

  • I have created all my views in query analyzer..But cannot lookup these views from the normal enterprise manager..In order to see the views I have to go the query analyzer and then look them up from the object browser..I dont know whats the reason for this but I wanna see my views from the enterprise manager..

    I would really appreciate if anyone could help me out in this

    Thanx in advance..

    Joel

     

     


    Kindest Regards,

    Joel

  • check the "owner" of the views and the login you are using to connect through EM

     


    * Noel

  • Also, don't forget to click on the refresh icon.

    Providing that the login that is used top register the database has the correct permissions this will work.

    Double-check which database you created the view in. This has caught me out a few times.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply