SQL Server 2005 - Permissions

Associate
Joined
28 Nov 2004
Posts
1,237
Location
Birmingham
Hi guys,
I'm porting some SQL 2000 db's over to our new SQL 2005 server and I want to make sure I'm setting up user permissions safely. Here's what I've done:

  • I restore the DB backup in to the 2005 server in 2000 compatibility mode.
  • I create a new server login with user mapping set to the correct database with the following role membership: db_datareader, db_datawriter, public
  • In the database properties - under permissions I grant the new user on the following: Connect, Delete, Execute, Insert, Select and Update
Is that correct? I have noticed a few references to schema's so should I be setting one of those up instead then applying the user to that schema?

Thanks for any advice you can give.
 
Back
Top Bottom