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 |
|
Kishortn
Starting Member
1 Post |
 Posted - 2006-07-07 : 03:37:41
|
| hi..I have created a user for my database. He has rights to execute stored procedure but not Select, Insert, Update or delete rights of tables.I have created a stored procedure in which i pass one input parameter.The value of the parameter is 'Select * From tablename'I want to execute this query in stored procedure but i am not able to do so.Is it possible to execute this sp for the user who dont have Select, Insert, Update or delete rights. If yes the how ?Please advise.Thanks in advance |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-07 : 04:00:16
|
| when you use dsql, you will need the underlying permission...why do you need to pass the select statement as a variable?--------------------keeping it simple... |
 |
|
|
|
|
|
SQL Permissions