Browse by Tags

All Tags » Execution context   (RSS)
How To: Share a Single EKM Credential among Multiple Users
SQL Server Extensible Key Management (EKM) requires the authentication information (user/password) to be stored in a credential mapped to the primary identity. This version of EKM cannot be used under an impersonated context; that is, you cannot access Read More...
Posted 03 October 09 04:16 by raulga | 0 Comments   
Filed under ,
Accessing the calling context in modules that use EXECUTE AS
In many occasions, marking a module (i.e. SP, trigger, etc.) with execute as can be really useful as it allows a controlled impersonation during the module execution; but at the same time there are many cases that it is necessary to access information Read More...
Posted 07 August 08 03:31 by raulga | 0 Comments   
Filed under
The TRUSTWORHY bit database property in SQL Server 2005
In SQL Server 2005 we introduced a new database property named TRUSTWORTHY bit (TW bit for short) at the database level in order to work as a safeguard to reduce the default surface area regarding some powerful new features: EXECUTE AS USER and CLR assemblies. Read More...
Posted 03 December 07 06:29 by raulga | 1 Comments   
Filed under
OPEN SYMMETRIC KEY scope in SQL Server
Recently I have heard a few questions regarding the scope of the SYMMETRIC KEY key-ring, especially when using modules (i.e. stored procedures) to open a key. One particular topic that got my attention is the impression that the OPEN SYMMETRIC KEY call Read More...
Posted 29 November 07 04:08 by raulga | 1 Comments   
Filed under ,

Search

This Blog

Syndication

Page view tracker