Post reply

The database principal has granted or denied permissions to catalog objects in the database and cannot be dropped

  • September 10, 2024 at 5:26 pm

    #4456228

    Just set all grantor to SA.  Who really minds who granted what permission.  It's going to be a DBA with sysadmin access doing it.

    update internal.project_permissions

    set grantor_sid = 0x01

    Tung Dang
    Azure and SQL Server DBA Contractor / Consultant
    DataZip

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply