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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-07-14 : 07:22:50
|
| A table is created called Table1then a stored procedure which is built dynamicaly queries table Table1should I first grant select on table1 to users ?It seems that the other stored procedures which are built using standard sql work fine when doing a select but not the ones which have been built using dynamic sql i.e. sp_sqlexecThanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-14 : 14:38:04
|
| Yes that's the problem with dynamic SQL. You can't just grant EXEC on stored procedures as the dynamic SQL doesn't run in the same session as the stored procedure. So users must have direct table access.Tara |
 |
|
|
|
|
|
grant