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

  • Thank for you reply!

    When I run the following query with the username I get 0 results which is why I'm confused to why it cannot be removed.

    select *

    from sys.database_permissions

    where grantor_principal_id = user_id ('USERNAME');

    Is there any chance that it could be that because the particular user is an owner of another database, that is the only thing I can think of?