If it's going through a service, then it will be the service's account whose
credentials and permissions are checked. If you want to use user X, then
you will have to use delegation.

Signature
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
Hello All,
I'm confused about permissions...
I have user X, who is a member of db_owner role.
I have stored procedures owned by dbo.
The database is owned by dbo (sa).
User X is making a connection from a "service", executing the stored
procedure,
but gets the "Execution permission denied" error...
I've checked for deny permissions but haven't found any related to user X...
It's my understanding that the db_owner has all permissions to do anything
within
the database... If this is incorrect, could someone recommend a good
book/white paper defining permissions... I would greatly appreciate it...
Thanks for your input...