0

Issue on apparent partial permissions but cant pinpoint. I have SQL-Server that allows trusted connections for Windows Authenticated users. C#/WPF app connection no problem.

The database has some functions, stored procedures and views, all common. Strangeness is that if the Windows login user is person "A", they get in no problem, access to what appears to be all the functions, procedures for querying report data, etc. However, person "B" on same network and trusted connection gets error on simple function within stored procedure.

For example, I have two otherwise very simple functions and have a stored procedure/query that does something like,

select
      func1( a.SomeField ) Func1Answer,
      func2( a.AnotherField ) Func2Answer
   from
      SomeTable a
   where
      a.Column = @passedParameterToProcedure

aside from the simplicity of this example, it works for person "A", fails for person "B". Both users on same Windows Authentication connection to server. Not passing explicit login user / password for connection.

Any ideas on how / where to search why this permission works for one and not another?

The error reported is:

User does not have EXECUTE permissions on FUNC1...

  • Why do you think that accounts A and B have the same permissions? Do you think that all Windows Authenticated users have the same permissions? – sepupic Jan 17 '18 at 7:53
  • You won't get anywhere by saying "it fails". What is the exact error message? And what permissions were given to the table for each of the users (or any roles they are assigned)? – SMor Jan 17 '18 at 16:50
  • @SMor, updated basic message, but there are no explicit permissions granted by me to these functions, yet it works for some people, not others. Hence the strangeness. – DRapp Jan 17 '18 at 19:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.