Showing posts with label theowner. Show all posts
Showing posts with label theowner. Show all posts

Tuesday, February 14, 2012

Default permissions for schema owner

Hi,
Can someone please list down the set of default permissions that the
owner of a schema gets by default ? Atleast the very basic and
important ones.
Thanks
AdyIn SQL Server 2005, you can use the Has_Perms_By_Name() function
(http://msdn2.microsoft.com/en-us/library/ms189802.aspx).
"audipen" <audipen@.gmail.com> wrote in message
news:1173160732.973389.165550@.64g2000cwx.googlegroups.com...
> Hi,
> Can someone please list down the set of default permissions that the
> owner of a schema gets by default ? Atleast the very basic and
> important ones.
> Thanks
> Ady
>