SQL EXPLORER
About Me
Mohamed Faizal
Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G
View my complete profile
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment