Community

Ownership chaining in SQL Server 2005

(Serdar Yegulalp) There are many occasions where multiple database objects access each other one after the other. One example is a stored procedure that invokes a view, which, in turn, invokes a table. When this happens, SQL Server has to evaluate the permissions on the referred objects. It does so

Read More - Register for Free Membership