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 |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2008-05-21 : 13:36:51
|
| what permissions one should have to insert data into table..?Thanks,ServerTeam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 13:39:03
|
| You need the INSERT permission.GRANT INSERT ON SomeObject TO SomeUserOrRoleTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-05-21 : 13:44:57
|
| if i give db_reader & db_writer also this works right..?Just want to confirm..Thanks,ServerTeam |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 13:49:10
|
| Yes but that provides more permissions than you've mentioned in your first post. We allow only exec on stored procedures, so our environment is very secure.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-05-21 : 13:52:45
|
| yes..Thanks,ServerTeam |
|
|
|
|
|
|
Insert permissions