Home Forums SQL Server 2008 Security (SS2K8) user mapped as dbo RE: user mapped as dbo
Arun S Prasad
Valued Member
Points: 55
More actions
August 6, 2014 at 8:29 pm
#1735825
Hi All,
When I changed the db owner to SA , I could delete the login.
The below code was helpful.. Thank you
USE [your_database];
GO
SELECT SUSER_NAME(principal_id)
FROM sys.database_principals
WHERE name = 'dbo';