SQL Server & BI Blog by Andreas Wolter - Latest Commentshttps://www.insidesql.org/blogs/andreaswolter/?tempskin=_atom&disp=commentsb2evolution2024-03-19T14:01:42ZIn response to: CONTROL SERVER vs. sysadmin/sa: permissions, system procedures, DBCC, automatic schema creation and privilege escalation - caveatsandreaswolter[Member]http://www.andreas-wolter.comhttps://www.insidesql.org/blogs/andreaswolter/2013/08/control-server-vs-sysadmin-sa-permissions-privilege-escalation-caveats#c83942018-10-15T08:30:50Z2018-10-15T08:30:50ZIn response to: CONTROL SERVER vs. sysadmin/sa: permissions, system procedures, DBCC, automatic schema creation and privilege escalation - caveatsS.E.[Visitor]https://www.insidesql.org/blogs/andreaswolter/2013/08/control-server-vs-sysadmin-sa-permissions-privilege-escalation-caveats#c83932018-10-15T07:37:11Z2018-10-15T07:37:11Z
Only a member of the sysadmin server role can add a job for a different owner with @owner_login_name. (Microsoft SQL Server, Error: 14515)
Only a system administrator can reassign ownership of a job. (Microsoft SQL Server, Error: 14242)
I tested this with the GUI but as far as I checked the code, the check is present inside the called SPs.]]>In response to: SQL Server Database Ownership: survey results & recommendationsandreaswolter[Member]http://www.andreas-wolter.comhttps://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c83922017-11-30T20:25:08Z2017-11-30T20:25:08ZIn response to: SQL Server Database Ownership: survey results & recommendationsMichael[Visitor]https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c83912017-11-30T10:01:39Z2017-11-30T10:01:39ZIn response to: SQL Server Database Ownership: survey results & recommendationsandreaswolter[Member]http://www.andreas-wolter.comhttps://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c83902017-11-12T19:10:10Z2017-11-12T19:10:10ZLogin disappeared
I have never seen that, but I will try a repro and get back to you, preferably on my new blog.]]>In response to: SQL Server Database Ownership: survey results & recommendationsMichael[Visitor]https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c83892017-11-08T15:38:30Z2017-11-08T15:38:30ZIn response to: SQL Server Database Ownership: survey results & recommendationsandreaswolter[Member]http://www.andreas-wolter.comhttps://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c83852017-02-07T23:09:57Z2017-02-07T23:09:57ZIn response to: Schema-design for SQL Server: recommendations for Schema-design with security in mindMarcus[Visitor]https://www.insidesql.org/blogs/andreaswolter/2016/02/schema-design-for-sql-server-recommendations-for-schema-design-with-security-in-mind#c83632016-10-27T11:28:22Z2016-10-27T11:28:22Z