Home Forums SQL Server 2014 Administration - SQL Server 2014 The database principal has granted or denied permissions to catalog objects in the database and cannot be dropped RE: The database principal has granted or denied permissions to catalog objects in the database and cannot be dropped

  • The error indicates the user has granted permissions to catalog objects. Have you checked for those permissions?

    select *

    from sys.database_permissions

    where grantor_principal_id = user_id ('USERNAME');

    You would need to revoke those permissions and then drop the user.

    Sue