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 |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2007-06-04 : 13:20:51
|
| Hi experts:Hopefully, this is is not such a silly question but what is the syntax for granting insert permission to a user?I have tried:Grant Insert on objectName to user;For instance:Grant Insert on BicTable to John Doe;but I get obhject doesn't exist.Thanks in advance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-04 : 16:44:20
|
| Does dbo own the table? Have to specify owner if not. |
 |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-06-05 : 11:26:09
|
quote:
Originally posted by simflex
Hi experts:Hopefully, this is is not such a silly question but what is the syntax for granting insert permission to a user?I have tried:Grant Insert on objectName to user;For instance:Grant Insert on BicTable to John Doe;but I get obhject doesn't exist.Thanks in advance.
check whether BicTable is present in DB or ...Mahesh |
|
|
|
|
|
|
Grant INSERT syntax