I am trying to run a stored procedure on the same database using two different login users. While using the Windows authentication , I'm able to run the stored and proc and see all the data available. But while running the same stored proc using a specific user authentication, I am not able to view the data. The stored proc is running but returning 0 rows.
The permissions for both accounts are the same.
Any suggestions on what might be the problem or how to approach in solving this issue?