June 15, 2003 at 8:03 pm
I have a sql server database which developer's are accessing remotely. Is it better to have one account for them all to use or should they each have an individual account?
June 15, 2003 at 10:26 pm
Hi
I would have seperate accounts, and lock away privs through roles (mix of db and user defined). Much easier to "remove" developers or disable accounts as they come and go.
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
June 16, 2003 at 4:27 am
I agree, you create issues with a single account with regards to security considering people do come and go.
June 16, 2003 at 9:05 am
This is a short term project...people will not be coming and going...will having seperate accounts for each of them create any conflicts during development?
June 16, 2003 at 10:26 am
No it will not create any conflicts. They however need to be carefull not to create the objects under their username but instead should make sure is dbo so that they are common to all.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply