Tag Archives: Logins

SQL Server security: Managing logins using stored procedures.

If you are a concerned DBA, you know that the rule of “least privilege” must be followed at all times. Even if something is not perfect right now, this is the direction to go and every step in that direction … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

“Alter User with login” equivalent in SQL2000

By now, most DBA’s must be familiar with “Alter user with login” command from SQL 2005 SP2 and above. But when only SQL 2000 existed we had to do a lot more things manualy. Migrating logins/users has always been a … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment