SQL Server Security Archives - Page 41 of 48 - SQL Authority with Pinal Dave

SQLAuthority News – Best Articles on SQLAuthority.com

November 4, 2007

Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

A list of my best articles so far, from killing all processes in a database and shrinking the log file to deleting duplicate rows and UNION vs UNION ALL.

SQL SERVER – 2005 – Get Current User – Get Logged In User

October 27, 2007

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server Security, SQL System Table

How to get current user for a query in SQL Server 2005: SELECT SYSTEM_USER returns the name of the current context, which helps with debugging and security.

SQL SERVER – Get Permissions of My Username / Userlogin on Server / Database

October 23, 2007

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL System Table

Invited to review a big company’s schema, I wanted to know my own permissions without asking their DBA. fn_my_permissions shows them at server and database level.