Transact SQL :- Error – Msg 15138 – “The database principal owns a schema in the database, and cannot be dropped”

Background Cleaning up a database as we move it from Development to Production. Recreate Drop User SQL Error Msg 15138 Error Text Error Image   Troubleshoot Metadata sys.schemas SQL Output Explanation Schema db_datareader The owner for the db_datareader schema has been assigned to a database account, other than itself Remediate Change Schema Owner ALTER AUTHORIZATION … Continue reading Transact SQL :- Error – Msg 15138 – “The database principal owns a schema in the database, and cannot be dropped”

SQL Server – Security – Privileging & Tracking the Guest Account

Background Each month we get databases from our Vendors.  And, we have to review data in those tables. There are a couple of pathways to quickly granting accessing to our users. In this post, we will grant access to the guest user.   SQL Grant Access Review Access Review Permissions grant/denied to Guest on Contextual … Continue reading SQL Server – Security – Privileging & Tracking the Guest Account