kevinsql7 (9/9/2013)
to assign permissions ... not sure why I had to do this. Do you know? With TestUser1 as the schema owner, it returns the following error:"Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself."
Yes, owner. If TestUser1 owns the schema you cannot grant TestUser1 any rights in it. Nor would there be any need to.
I thought because I made the username and schema name the same this caused a problem. I guess it is just not a 'good practice' with SQL Server 2005 and later to make them the same.
It all depends on what you want to achieve. It is the old pattern from SQL 2000 that I did not see much point with, but not all shops are alike.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]