Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

Sys fn_builtin_permissions(NSERVER)

SELECT class_desc 'class',     permission_name,     covering_permission_name 'covering_permission',     parent_class_desc 'parent_class',     parent_covering_permission_name 'parent_covering_permission' FROM sys.fn_builtin_permissions(N'SERVER') WHERE permission_name = 'ALTER ANY LOGIN' GO