If the user logs in he can access to the schema to which the user has rights.
And the also it is not necessary to use schema name for the tables which user has rights.
Means user can access the table as select * from table_name instead of select * from schema.table_name.
My main concerned is when we use "Shared Database, Separate Schemas" in sql azure for multi-tenancy the tables and stored procedure can be accessed without schema name.
The schema along with the data objects(tables,stored procedure) are created dynamically.
The problem is that how to access the functions (because the functions needs to be accessed with schema name).
And this functions are called from stored procedure (currently it is called as select dbo.function_name).
Is there any way we can call the functions without schema name???
Does "Shared Database, Separate Schemas" in sql azure supports user defined functions???
Hi - Eventhough the schema is constructed at runtime, you should be able to prefix it with database owner scheme (dbo) and execute the functions. I am assuming along with creating runtime tables and SP's you are also creating functions at runtime.