Deleting an owner
-
I've deleted this owner from all the tables and roles that I can see it was attached to yet I still get this message:
Error 15284: The user has granted or privileges to the following in the database and cannot be dropped
Is there anything else I can check to see what it's an owner of? Need help
Thanks,Kris
-
Try
select *
from sysobjects
where uid 1
Hopefully that will show you where the problem is.
----------------
Jim P.A little bit of this and a little byte of that can cause bloatware.
-
That has confirmed that the owner I'm trying to delete does not exist on the database, yet still won't let me delete it.
Thanks,Kris
-
Open "Users" folder for this database and check if this account (login) is mapped to "dbo" user. If yes - fix it with procedure sp_changedbowner.
-
how about querying sysprotects ?
the errormessage is pointing to authorities granted by the user you want to be dropped.
select user_name(grantor), *
from sysprotects (nolock)
where grantor = USER_ID ( 'youruser' )
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
ok, I did
select user_name(grantor), object_name(id), *
from sysprotects (nolock)
where grantor = USER_ID ( 'the_user' )
but object_id(id) is null
any ideas on the next move?
thanks
-
whoops, I meant
object_name(id) is NULL
-
This question is over five years old. Please just open a new question and explain your issues.
----------------
Jim P.A little bit of this and a little byte of that can cause bloatware.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply