Database Reference
In-Depth Information
Figure 4-7.
Viewing the new schema owner
However, you aren't done just yet. MyTestLoginUser can no longer see the table. Issuing a
select
statement on the table returns an
Invalid object name
message, as shown in Figure 4-8.
Figure 4-8.
Error when the user
can't
see an object
The default schema of MyTestLoginUser is DBO, as shown in Figure 4-9. The default schema of a
user is the schema that's used if none is specified in a T-SQL statement. To make it easier on developers,
change the default schema to MyReadOnlySchema, so it doesn't have to be specified in T-SQL
statements.