locked
Symmetric Key RRS feed

  • Question

  • Hi All.

    is it possible we can deny 'dbo' of a database to drop an symmetric key ?

    Monday, March 10, 2014 4:18 AM

Answers

  • You Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

    Andreas Wolter (Blog | Twitter)
    MCM - Microsoft Certified Master SQL Server 2008
    MCSM - Microsoft Certified Solutions Master Data Platform, SQL Server 2012
    www.andreas-wolter.com | www.SarpedonQualityLab.com

    • Proposed as answer by Fanny Liu Tuesday, March 11, 2014 8:19 AM
    • Marked as answer by Fanny Liu Tuesday, March 18, 2014 1:35 AM
    Monday, March 10, 2014 9:29 AM

All replies

  • Refer special case section under this link,

    http://technet.microsoft.com/en-us/library/ms187359(v=sql.90).aspx


    Regards, RSingh

    Monday, March 10, 2014 6:56 AM
  • means cant ?
    Monday, March 10, 2014 7:32 AM
  • You Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

    Andreas Wolter (Blog | Twitter)
    MCM - Microsoft Certified Master SQL Server 2008
    MCSM - Microsoft Certified Solutions Master Data Platform, SQL Server 2012
    www.andreas-wolter.com | www.SarpedonQualityLab.com

    • Proposed as answer by Fanny Liu Tuesday, March 11, 2014 8:19 AM
    • Marked as answer by Fanny Liu Tuesday, March 18, 2014 1:35 AM
    Monday, March 10, 2014 9:29 AM
  • means cant ?

    Correct.  The database owner as full permission on all objects inside the owned database, hence the documented restrictions.

    Perhaps we can suggest an alternative if you provide more information about your use case for wanting to do this.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    Monday, March 10, 2014 11:17 AM