sp execute permission - 08-29-2007 , 11:02 PM
I have a .Net 2.0 windows app that connects to a SQL Express
I have 2 Clients using it fine. It accesses stored procs to
The clients use integrated security.
data source='SQLSERVER\SQLEXPRESS';initial catalog=tbrPData;integrated
The problem is on the third client I get
Exsecute perimission denied on sp message.
It also uses integrated security.
How do I find out what user this client is accessing the DB with???
Re: sp execute permission - 08-31-2007 , 01:10 AM
well it must be a windows group because the other clients
So how do I find out what windows group there are??
In the activity monitor it show the individual users like this
But I have not setup permissions for them to my sp.
I had to explicitly add execute permissions to Lester/RebeccaC
but not the others??
So how do they work?
"Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote