Post reply

How I can Give Permission to users to access a database

  • October 20, 2009 at 7:11 am

    #212500

    I Have a Question, How I can give Permission to access a particular database to a particular user from SQL Server Management Studio 2005.

    Like i Have a DB name "Test", When a user click on that database expand button then only authorized persons can open the tables. Like a Database Server Hosting Personals give Permssion only to the DataBase owener.

  • October 20, 2009 at 7:15 am

    #1068158

    By creating the user, you give them access to the database. However that does not give them access to any objects (tables/views/stored procedures).

    For that you need to give rights to objects. What I suggest is you create a role in the database, add the user to the role, and then use the GRANT (or the dialog in SSMS) to give rights to objects.

    Is this for a regular user to access the db, or a developer/power user? There are some built in roles for reading and writing to all tables.

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

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