Re: SQL sp execute perimmsion

Tech-Archive recommends: Speed Up your PC by fixing your registry

well it must be a windows group because the other clients
work fine

So how do I find out what windows group there are??

In the activity monitor it show the individual users like this

Lester/Marlene
Lester/Bayu
Lester/Suzanne
Lester/RebeccaC

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?


"Ignacio Machin ( .NET/ C# MVP )" <machin TA laceupsolutions.com> wrote in
message news:%23dKPJTx6HHA.1164@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

"Rotsey" <malcolm_smith@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OhOmsqr6HHA.2632@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have a .Net 2.0 windows app that connects to a SQL Express
DB.

I have 2 Clients using it fine. It accesses stored procs to
update data.

The clients use integrated security.

data source='SQLSERVER\SQLEXPRESS';initial catalog=tbrPData;integrated
security=SSPI

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???

Install the management studio, there you will have a profiler that shows
you the actions in the DB, What kind of security you have in your DB?



.

Relevant Pages

  • Re: Access Project Deployment
    ... If you and your clients are in a trusted domain environment, how about using Windows Authentication method to authorize your users? ... Create a Windows Group and make your clients member of that group and then go to SQL Server. ... Create a login for that Windows Group and give them necessary rights and permissions so that they will be able to connect to the mentioned database. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL sp execute perimmsion
    ... It accesses stored procs to ... update data. ... The clients use integrated security. ...
    (microsoft.public.dotnet.languages.csharp)
  • sp execute permission
    ... It accesses stored procs to ... update data. ... The clients use integrated security. ...
    (microsoft.public.sqlserver.clients)
  • SQL sp execute perimmsion
    ... It accesses stored procs to ... update data. ... The clients use integrated security. ...
    (microsoft.public.dotnet.languages.csharp)