var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Deleting users
What is the easiest way to delete a user account?
I ask because sp_droplogin gives me a message, something about the user being an owner of objects.
I'm not sure of how to proceeed
do you want to drop a login from the server or
do you want to drop a user from a certain database?
if a login is still owning objects , i.e. has rights within a database of that server and owns a procedure or sth. you can't drop her, you first have to drop the objects which the login owns ....
Thanks for the reply,
Yes, I want to drop a user from a database.
So, if I understand you correctly, I have to first drop that particular users ownership of objects and then drop the login?
Forgive me for asking, but how do I find this info? sp_displaylogin does not show me much.
And once I find it how do I go about removing these objects from the user?
you want to drop a user from the database
> use <database>
>sp_dropuser <user you want to drop>
or use sybase central instead if you don't like the commend shell
I'm assuming all objects within a database are owned by dbo
and individual users are granted using these objects via a role
when the user is dropped successfully
>sp_droplogin <login to be removed>
That was what I needed to know.