I've been going through learning SQL and one thing I'm confused on is the fact that users can get their own tables. In one of my tutorial videos the guy briefly mentions how the chain of owndership works, and how SQL will first look for a table with that users name first, before the DBO table.
Is Mike.Employees a table that Mike can grant other people access to? Is a DBA the only person who can grant access to Mike.Employees?
Is Mike.Employees a table that Mike can grant other people access to? Is a DBA the only person who can grant access to Mike.Employees?