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 |
|
tfountain
Constraint Violating Yak Guru
491 Posts |
 Posted - 2009-02-25 : 16:58:06
|
| We have process in place that detects ophaned database users and removes them from the database they are found in. The reason behind this is we have a policy to only user server logins and grant permissions to them. Makes my life much simpler! Anyway, we have one user that managed to grant permissions to some certificates and keys that needs to be removed but when executing sp_RevokeDBAccess, the error The database principal has granted or denied permissions to objects in the database and cannot be dropped. is generated. Is there a way to drop this user and maintain these grants? |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2009-03-02 : 16:12:23
|
| No thoughts / opinions? |
 |
|
|
|
|
|
Error executing sp_RevokeDBAccess