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 |
|
roshana
Starting Member
31 Posts |
 Posted - 2010-06-03 : 12:14:37
|
| Hi All,I am developing a new website ,I have around 45 tables there ,how can I restrict user access to these tables ie the application user should have select, insert , delete & update operation .I cannot create any views or schema because the development phase is 50% done. How can I restrict the application user from dropping tables and running malicious code ?, I am using entity framework 4.0 and SQL server 2008 enterprise edition.Thanks,Roshana |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-06-03 : 15:42:56
|
| You can DENY Drop permissions... on the objects for the users..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Table restriction