I'm trying to understand the actual use case. That is, why do you have this permission setup in the first place? The user can create procedures in the schema and...

As John says, stay away from the UI. It's more confusing than helpful.

Create the role with CREATE ROLE (not sp_addrole, that's an old and mouldy command). You don't want a...

I would agree with Roger. The developers need a sandbox environment where they can do whatever they need. Particularly, they need to be able to set up the jobs they...

Well, by the default users does not have access to jobs at all...

If you want to give users permission to start a certain job, look this article on my web...

If you opt to insert only the names into the table, I suggest that you save quotename for later.

You can execute the table in this way:

SELECT @sql =

...

Run this query, review the result set and execute it:

SELECT 'REVOKE VIEW ANY DEFINITION FROM ' + quotename(name)

FROM sys.server_permissions sp

JOIN sys.server_principals p ON sp.grantee_principal_id = p.principal_id

WHERE...

When you change the service account in the SQL Server Configuration Manager, it will assign the required windows permissions to the account.

However, there are two permissions that are not granted,...

As I understand it, membership in sysadmin means that all permissions checks are waived.

Not sure what question does in the Security forum, since neither locks nor latches has anything to do with security.

Latches are short-term locks that SQL Server takes for physical operations...

What is the actual error message? And where do you get it? The message you quote is far from the regular error message:

The EXECUTE permission was denied on the object...

To enable SQL Server authentication, if that is your question, right-click the server-node in Object Explorer, select Properties, go to the Securities page. You need to restart the server for...

I never use Persist Security Info, and I will have to admit that I really know the effect of it.

Wether to use Integrated Security=SSPI, or Username + Password depends on...

Not sure if I understand the question, of if it was even meant to be a question.

But a login maps do dbo in a database if:

1) The login owns the...

DDL trigger on server level? Or for that matter a DDL trigger inherited from model?

The DENY does not come out of nowhere (but they take precedence over any GRANT, and...

Now you only need to check in sys.database_principals who principal_id 6 is. Presumably it is a Windows group.

This this appears to occud in many databases, also chcek model, since...