0

I am trying to list all current permissions for db_owner and sysadmin for SQL Server 2012. I found these SPs:

EXEC sp_srvrolepermission 'securityadmin'
EXEC sp_dbfixedrolepermission 'db_owner'

However, these are deprecated and only accurate as of SQL Server 2000. Is there an equivalent mechanism to accomplish the same thing today?

1 Answer 1

2

Neither of these roles has an enumerated list of permissions. db_owner has all permissions in a database, and sysadmin is exempt from permissions checking on both the server and every database. There are a handful of system procedures that are hardcoded to check for sa or perhaps dbo.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.