Tag Info

New answers tagged


Don't grant ssis_admin if the dev shouldn't be sysadmins: Members of the db_ssisadmin role and the dc_admin role may be able to elevate their privileges to sysadmin. Source: https://msdn.microsoft.com/en-us/library/ms141053.aspx Personally I would never let the devs create jobs with their accounts. As soon as they leave the company and someone ...


I don't know of a way to access such a list via a query but IBM provide a list of user views and system views in their Knowledge Centre. I assume those pages are public because their website tells me I'm not currently logged in (but it's not the most user-friendly of sites in terms of authentication so I may be wrong). EDIT: As Craig pointed out in his ...

Top 50 recent answers are included