Post reply

Retricting access to DB objects for certain users

  • May 19, 2008 at 12:39 pm

    #96302

    In SQL Server 2000, I am trying to give someone SELECT permissions to certain views in the DB. So, I created a role that has select permissions to those views and added a user with that role.

    I then tested to make sure. Although the user can only run select queries on those views, the problem is that when the user logs in using Enterprise manager, he can see ALL the tables, view, SPs, etc that he does not have permission to. I don't want him to see all those objects an the structure of the DB.

    How can I make it such that he can only see the views I gave him access to?

    Thanks.

  • May 19, 2008 at 1:34 pm

    #817422

    Enterprise Manager is not a user tool. It is an administration tool. Don't give a plain-Jane user EM.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • May 19, 2008 at 1:50 pm

    #817427

    I know that much. And nothing stops the person from downloading/installing his own copy of EM and connecting to the DB.

    The other reason I asked the question was if I had some part-time developers (that would need to use EM) working on a projects and I only wanted them to see certain objects.

    Is there a way to limit the objects they see in EM?

  • May 19, 2008 at 3:05 pm

    #817465

    You can't hide objects in Enterprise Manager. If someone has access to the database, they get to see everything.

    Greg

  • May 19, 2008 at 3:31 pm

    #817488

    Thanks. That's all I needed to know.

Viewing 5 posts - 1 through 4 (of 4 total)

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