About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Wednesday, January 7, 2015

Error dropping the user : The database principal owns a schema in the database

SELECT s.name
FROM sys.schemas s
WHERE s.principal_id = USER_ID('ssrs')

-- now use the names you find from the above query below in place of the SchemaName below


ALTER AUTHORIZATION ON SCHEMA::db_datareader TO dbo

No comments:

Post a Comment