Browse by Tags

Fine-grained Server Roles

Hi, I need to have a windows authenticated user who's able to create logins and grant database roles, and nothing else (no T-SQL on any object). Is it possible to grant ONLY those privileges to a database user ? I'm asking because for Oracle target environments, I used "grant CREATE USER...

Posted to SQL Dev (Forum) by djobin on Wed, Oct 1 2008
Preventing Microsoft Excel or any other application from connecting to SQL Server 2005

Today, I was asked a question on how to prevent Microsoft Excel from connecting to SQL Server. At first I wasn’t sure how to respond to this, but I finally found a way. It is a simple trick that uses the FOR LOGON option now available since the SP2 release of SQL Server 2005. USE master GO CREATE TRIGGER...

Posted to MS SQL Admin (Weblog) by Eric Vaillancourt on Fri, Mar 28 2008
Auditing Logins in SQL Server 2005

When I teach my SQL administration classes, I'm often ask if SQL Server provides a mechanism to log user logins. Before SQL Server 2005 SP2, this task was possible but not reliable. In SQL Server 2005 this task is easy to implement using DDL triggers (Data Definition Language). One reason that people...

Posted to MS SQL Admin (Weblog) by Eric Vaillancourt on Fri, Mar 28 2008

Page 1 of 1 (3 items)