sql server 2000 security

• sharon-644450

  Default port

  Points: 1442

  More actions

  April 10, 2008 at 7:04 am

  #154273

  hi ,

  i have to give access to a user so that he can sst up dts package and push in data to my sql server. i created a login for him and gave him the necessary permissions. now i do not want him to see any of my system d/bs eg. i do not want him to see any of the tables in the amster d/b nor modify them how do i set this thing up. if i give denydatareader role to master i can not login with the user name that i created.

  thanks for the help.

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  April 10, 2008 at 7:58 am

  #800987

  You should post this in the SQL 2000 portion of the forums.