Browse by Tags

Let a user with minimal privileges see another user, simple with TSQL - SQL Server 2005

Published 11 March 8 7:5 PM | SSQA.net

You may be aware that by default, users that have minimal privileges cannot see other users in the sys.database_principals and sys.server_principals catalog views. This means that a user with minimal privileges that owns a table cannot see other users...

Filed under: sql server, BOL, permission, tsql, privilege, user schema, definition

Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005

Published 24 July 7 6:21 AM | SSQA.net

As a DBA you might have come across this situation where you have forgotten the sa password for SQL Server - so what can you do? If you are experienced with such situation then definetly you might have an alternative solution to keep the passwords in...

Filed under: sql server, security, disaster recovery, sa, password, sysadmin, privilege