Calling a user defined function without Schema
I created a LOGIN User U1 and CREATED a database user DU1 and linked him with the Login User and I created a schema say S1 and set S1 as the default schema for DU1 .
I have a stored Procedure and a userdefined function inside S1 . I logged in as the Login user,
I can execute that procedure directly without any schema prefix but I cannot call a user defined function F1 directly (without schema prefix)
. it throws an exception
"function name is not a recognized built-in function name"
How can i call a UDF directly with out a schema prefix
THE STEPS I FOLLOWED ARE :
--Login User Creation
CREATE LOGIN S11 WITH PASSWORD = 'Passw@rd!';
--Database User Creation and assign to default schema
CREATE USER S11 FOR LOGIN S11 WITH DEFAULT_SCHEMA = S2;
--Giving User Privilege
EXEC sp_addrolemember db_owner,'S11'