Steve Jones - SSC Editor
October 14, 2018 at 5:39 pm
Comments posted to this topic are about the item Being Careful with Schema Ownership
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 15, 2018 at 10:41 am
Thank you for the post Steve. What thoughts do you have about having a role own the schema?
October 15, 2018 at 11:56 am
Hadn't thought about that. Can a role own a schema? I thought schemas needed a person that owned them, but if a role can do it, without any issues, I'd prefer something built into the product.
October 15, 2018 at 12:29 pm
I see that you can. I suspect that using db_ddladmin or db_dbowner is the same as dbo. Not sure I'd like a user role or app role, but haven't thought enough about it.
October 15, 2018 at 12:42 pm
I once read somewhere that when you're connected as the owner that permissions don't need to be checked when performing operations. Is this a significant performance gain?
October 15, 2018 at 1:31 pm
No, very minor check. Some checks are still needed, but even if you say
select * from mytable
select * from dbo.mytable, the permission check is minor.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply