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:
Thanks for any advice you can give.
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
Thanks for any advice you can give.