Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danyeung
Posting Yak Master
102 Posts |
 Posted - 2008-01-10 : 14:23:17
|
| I deleted a login name from the server Security - Logins. The login name was added to the database (myDatabase) permissions before it was deleted. I meant right click at myDatabase. Select Properties, and the Permissions tab. What is the command for removing the login name from myDatabase Permissions?I did it from the Query Command window yesterday using maybe EXEC SP_????????? but I could not find it again on the web. Can someone please help me with this?Thanks.DanYeung |
|
|
sshelper
Posting Yak Master
216 Posts |
Posted - 2008-01-10 : 14:33:07
|
| Try the sp_revokedbaccess system stored procedure.SQL Server Helperhttp://www.sql-server-helper.com |
 |
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2008-01-10 : 14:46:49
|
| That is it. Thanks.DanYeung |
|
|
|
|
|
|
Remove a login name in a table.