Post reply

Hiding objects in Enterprise Manager

  • February 16, 2004 at 11:16 am

    #160751

    HI. Is there a way to not show certain branches in enterprise manager? for example, say you only want someone to have use EM to work on a database only and you don't even want them to see the SECURITY,  or MANAGMENT branches. Is there a way to do this? I know you can set security to prevent people from being able to add security and things as such, but I am under the thinking, the less people SEE the better.

    any ideas??  

    Juanita

  • February 16, 2004 at 4:20 pm

    #494284

    Hi Juanita,

    First of all, you are correct that the SQL EM will not let people do anything that they don't already have permission to do.  But I'm afraid that you can't strip down what it displays (other than the registration property for each server that lets you hide system objects and databases).  To do what you want, you write your own SQL-DMO code to encapsulate just the functionality you want the users to see - sounds like too much work to me, but it might be worth it to you.

    The flip side of not wanting the users to see some of those branches is that at least it gives them a reference point for when you want to talk about the difference, say, between a login and a user.  For developers especially, SQL EM can help them understand the server a little better maybe.

    My last thought is that you might want to look for a third-party tool.  Somebody just announced that there is a new version of TOAD for SQL Server available at http://www.toadsoft.com.  I have downloaded it and haven't played with it yet, but the Oracle version of Toad is very non-DBA focused, so maybe the SQL version will be close to what you want.  Also, you might want to take a look at DB-Visualizer.  Our developers here use it a lot.  It lets them do a lot of what they want to do, without giving them interfaces for the kinds of DBA-only things you are talking about.  DB Viz does require jdbc drivers, however.  It is available at http://www.minq.se/products/dbvis/index.html.

    Cheers,

    Chris

  • February 17, 2004 at 7:39 am

    #494352

    Thank you so much for the clarification and for the tool suggestions!!

    Juanita

     

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

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