THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Security » SQL Server Agent   (RSS)
Sorry, but there are no more tags available to filter with.
  • Using sa as owner for jobs and databases

    This blog is not about avoiding logging in using the sa login. Hopefully we all know about this, and work towards avoidning this practice. Instead I want to talk about using sa, but not to login (authenticate), but as owner for jobs and databases. I want keep these thing de-individualized - so we avoid things like person A leaving the company and ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on December 30, 2009
  • SQL Server Agent jobs and user contexts

    In what user context does a job run? I recently found myself in a forum discussion and gave my stock reply, later realizing that I haven't actually tested this for a long time (I used to demo this in class during 6.5 courses - when we actually had time for slight diversions). Lets start with my assumptions: Job owned by sysadmin, TSQL ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 19, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement