July 7, 2017 at 6:19 am
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.
July 7, 2017 at 6:27 am
Ha, no sooner had I posted than I realised that someone had configured the Windows User to be an Adminstrator of the local machine. AND (and this will be revoked) BUILTIN\Administrators were SysAdmins in SQL Server.
I hope this helps someone else.
Giles
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply