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 |
|
hai
Yak Posting Veteran
84 Posts |
 Posted - 2008-11-17 : 09:05:27
|
| I have a developer complain all the time about the security of the database. The reason for this is that complain is that from development environment work fine, but when upload to the production, the database complain of no access permission to the database table, store proc, view, etc. What is the best way to check or handle these with permission and access change, beside add the group to the sysadmin.thanks |
|
|
karthickbabu
Posting Yak Master
151 Posts |
Posted - 2008-11-17 : 09:22:25
|
| Whenever your write the code, use dbo.Table_Name, dbo.SPName etc etc...Somewhere its not needed. Refer BooksOnline. It will be helpful==================================================== you realize you've made a mistake, take immediate steps to correct it. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
|
|
|
Database secruity....