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 |
|
krisrajz
Starting Member
19 Posts |
 Posted - 2011-01-04 : 23:18:20
|
| Hello,How do I revoke drop table from all users of a database?!Thank youRegardsRaj |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-01-05 : 00:18:41
|
| Do you mean you want to allow them to create tables but not drop them?You can remove alter schema permissions.Assuming they are not sa or dbo or ddl admin or table owners or have been granted specific permissions on the table (not sure if that's possible without one of the others).Are your users given permissions via roles? If not it'll probably be difficult to control.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Revoking drop table