What does the function ORIGINAL_LOGIN return in SQL...

What does HAS_DBACCESS() do?

You cannot remember what permissions that the db_accessadmin...

When a user on a remote SQL Server...

Pop Rivett's SQL Server FAQ No.5: Pop on the Audit Trail

Pop provides a cunning, trigger-based technique for auditing the activity on SQL Server tables

Security Enhancements in SQL Server 2005: Schema

Security has become more and more important in today's business environment. From the database point of view, DBAs and system administrators need an improved security model. SQL Server 2005 provides an improved security feature. It is claimed that SQL Server 2005 is secure by default. In SQL Server 2005, the security model is divided into three areas namely authentication, authorization, and encryption.

Which of the following modules within SQL Server...

Tales of Corporate Espionage

All good detective stories have a femme fatale. In the case of corporate espionage scandals, Celia Goodson, a seasoned businesswoman and once a glossily groomed blonde, has been involved in investigating more business transgressions to hit the City in the last three decades than anyone else of her years.

Your Field Guide To Designing Security Into Networking Protocols

We'll go over some examples of attacks against protocols and rules following, which will help you when designing and implementing protocols of your own.

When you attach or detach a database, which...