Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Can I give permissions on specific objects, so what I can do is just give the user restrict permissions to do not drop on those tables.
Posted
Comments
Sandeep Mewara 13-May-12 9:22am    
Yes.

1 solution

Try following;
deny drop permission to user

For detail please navigate the following link:
DENY Object Permissions (Transact-SQL)
 
Share this answer
 
v2
Comments
Manas Bhardwaj 13-May-12 6:39am    
my 5!
Monjurul Habib 13-May-12 6:53am    
thank you :)
Sandeep Mewara 13-May-12 9:23am    
5 Monjurul.
Monjurul Habib 13-May-12 15:26pm    
thank you :)
VJ Reddy 13-May-12 20:53pm    
My 5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900