When try to call to object without write the specific schema:
- dbo/db_owner/sysadmin doesn't find an object from another schema - because dbo/db_owner/sysadmin doesn't try to find objects in other schemas, Unless another schema is written Explicitly.
- Other Users/Schemas/Rools try to find the objects in their schema, and if it's not exists - they will try to find the objects in dbo schema.
No comments:
Post a Comment