Post reply

how to provide security by hiding unwantedsql server objects in sql server 2005

  • August 11, 2008 at 11:01 pm

    #211125

    HI all,

    i want to provide database access to the client.But in my production database server i have more than one database.just i want to display only single database among the other databases.

    similarly i want to display few tables among the no of table object.Please can any one suggest this where i can find this option to restrict to specific objects for the user.

    Thanks,

    Thulasi.

  • August 12, 2008 at 10:29 pm

    #857166

    You can't prevent them from seeing all the databases. However, once they are in the database, with SQL Server 2005 any queries against metadata will only return to that user the objects they have access to. So if they don't have access to a particular table, SQL Server won't show them anything about it.

    K. Brian Kelley
    @kbriankelley

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

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