Re: Default permissions for schema owner


In SQL Server 2005, you can use the Has_Perms_By_Name() function
(http://msdn2.microsoft.com/en-us/library/ms189802.aspx).



"audipen" <audipen@xxxxxxxxx> wrote in message
news:1173160732.973389.165550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Configuring users
    ... Currently only the owner, the DB owner or someone with system administration ... permissions can alter an sp... ... Wayne Snyder, MCDBA, SQL Server MVP ... > permission but this doesn't allow them edit. ...
    (microsoft.public.sqlserver.server)
  • Re: Permissions
    ... Do the objects have the same owner ... I have a table, myTable, in a schema named Schema1. ... The permissions on Schema1.myTable are left unchanged (no ... This is Sql Server 2005 Standard, ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot remove dbo rights from a user
    ... The properties of the database ... It showed the owner as our system ... I do not want him to have dbo permissions. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Access 97 -- how to get to VBA code?
    ... dbo (as in sql server) is the owner, ... permissions. ... The macros are found under the Macro tab, along side Tables, ...
    (comp.databases.ms-access)
  • Default permissions for schema owner
    ... Can someone please list down the set of default permissions that the ... owner of a schema gets by default? ... Atleast the very basic and ...
    (microsoft.public.sqlserver.security)