Hi,
I've got a Windows Authenticated User logging into a Database but when they attempt to execute a Stored Proc without the Stored Procs Schema it fails saying the Stored Procedure could not be found.
When that User executes the stored proc prefixing with the Schema it works fine.
The Schema of the proc is "interface" as is the users Default Schema.
There is a Role which has the execute permission to the "interface" Schema and my user is a member of that Role, although that Role is itself a member of db_datareader (not my design).
They are NOT a member of any Server Roles. They don't own any Schemas (although they did until I removed them)
I've also got another Windows Authenticated user with the same Default Schema and Role membership and it works perfectly fine for them without specifying the Schema. They look identical.
SQL Server 2016 Standard Edition on Windows Server 2016 Standard.
So can anyone tell me where else I can check please?
Thanks very much
Giles.