Welcome to Romanian SQL Server User Group Sign in | Join | Help

Browse by Tags

All Tags » SQL Server Execution Context   (RSS)

Dynamic SQL and digital signatures in SQL Server 2005

As I already mentioned, dynamic SQL is a quite powerful, but also quite dangerous. In SQL Server 2005 we introduced a new feature that is also quite powerful and when used properly can be quite useful; but it is important to learn and understand any such Read More...
Posted 9 mai 2007 20:42 from Raul Garcia's blog | (Comments Off)

Using a digital signature as a secondary identity to replace Cross database ownership chaining

In SQL Server 2000, Cross database ownership chaining (CDOC) was a mechanism used to allow access (DML access) to resources on different DBs without explicitly granting access to either the target DB (the DB where the actual data was stored) or to the Read More...
Posted 31 octombrie 2006 04:53 from Raul Garcia's blog | (Comments Off)

Quick guide to DB users without logins in SQL Server 2005

SQL Server 2005 introduced a new SQL DB principal subtype that can be quite useful: a SQL user that is not mapped to any login. You may be asking yourself “Why is this feature interesting? after all SQL Server already had the ability to create SQL users”, Read More...
Posted 4 iulie 2006 00:25 from Raul Garcia's blog | (Comments Off)