Microsoft SQL Server has the concept of a database owner. The most common of these is “dbo”, the default database owner.
The account you use to connect to the Microsoft SQL Server (Windows Authentication or SQL Server Authentication) must have access to the tables even if owned by a different user. For example, if you have database tables owned by dbo, user1, user2, etc., and you are connecting to the database using user1, then user1 must have access to the tables owned by dbo, user1, user2 and other users. If not, your application will not display any data.
Microsoft SQL Server 2005 added support for schemas and differentiated them from database users. A schema in Microsoft SQL Server 2005 is a collection of database entities that forms a single name space. Iron Speed Designer recognizes the different schemas and creates the appropriate query to read or write data from the tables. Note that the Data Access Layer classes created by Iron Speed Designer use the table name as the class name and must be unique even if the tables are in two different schemas.