Re: sql2k5 security

I guess I am missing something. In SQL 2000 I was able to give a user only
Execute permissions on a stored proc and the stored proc was able to perform
select/insert/update/delete operations fine. Now this doesnt seem to work in
SQL2005? I have to explicity give the user select/insert/update/delete
permissions on the tables?


"Wei Lu [MSFT]" <weilu@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uSb9cOelGHA.4164@xxxxxxxxxxxxxxxxxxxxxxxx
Hi param,

Have you got any further ideas on this issue or does my last reply also
help some? If there is still anything we can help, please feel free to
post
here.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.



.