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