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

  • August 9, 2016 at 2:36 am

    #1894476

    John Mitchell-245523 (8/9/2016)

    You have replaced "USERNAME" in that query with the name of the login you can't drop, haven't you? And you are running the query in the correct database context (SSISDB)? What does this return?SELECT DISTINCT(SUSER_NAME(grantor_principal_id))

    FROM SSISDB.sys.database_permissions

    John

    Thank you for your reply!

    Yes, I have replaced the 'username' with the login I need to remove but no results are returned.

    When I run the following script I get 'sa' result back

    SELECT DISTINCT(SUSER_NAME(grantor_principal_id))

    FROM SSISDB.sys.database_permissions

    Thank you