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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-09-22 : 08:25:06
|
| How do I remove/drop a user from a schema as they no longer required within it? |
|
|
Sequin
Starting Member
25 Posts |
Posted - 2009-09-23 : 05:05:21
|
| USE DatabaseNameDROP USER [username]If they are owners of any object within the database, you will have to reassign the ownership before it will let you drop the user |
 |
|
|
|
|
|
how to remove a user from a schema?