Home Forums SQL Server 2008 T-SQL (SS2K8) Enable 'Allow modifications to be made directly to the system catalogs' RE: Enable 'Allow modifications to be made directly to the system catalogs'

  • USE [database name]

    SELECT u.name 'User', o.name 'Object', p.permission_name 'Action'

    FROM sys.database_permissions p, sys.database_principals u, sys.all_objects o

    WHERE o.object_id = p.major_id

    AND p.grantee_principal_id = u.principal_id

    AND p.grantee_principal_id IN (0, 2)

    ORDER BY u.name, o.name, p.permission_name

    It is displaying a list of SELECT and EXECUTE.I can delete all except the last 26 which are a mix of the two.