Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    2

    Question Unanswered: Restricting Access to a Database

    Hi,
    I am using MS-SQL 2000. I want to restrict the use of the database to a single person. That is to person A only. Only he will be able to add the tables or views or do anything in that database.. others should have only read permission in that database. Can anybody tell me how to do this..

    Thanks
    Raghupathy K

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Assign that 1 user the role of db_owner and all other users db_datareader.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •