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 7:41 am

    #1894521

    SeniorITGuy (8/9/2016)

    tt-615680,

    In SSISDB, internal.object_permissions is a view that unions four tables.

    Those tables are:

    internal.operation_permissions

    internal.folder_permissions

    internal.project_permissions

    internal.environment_permissions

    Check each of those tables for entries for the user you want to drop and remove them from these tables first and then try your drop user operation again.

    As always, back up your tables before dropping any rows.

    Hope this helps!!

    Jon

    Thank you for your reply, I want to know how I'm able to find the user I'm trying to remove as the script I run earlier did not work e.g. the sid or grantor_id?

    Thank you