October 14, 2015 at 12:32 am
Hi,
I have SQL Server 2008 R2 SP2.
I have two tables with the same name but in different scheme.
The table is called cmobjects.
The first table is dbo.cmobjects with 600 records.
The second table is finan.cmobjects with 305 records.
The database is named ControllerCS and the user "finan" is db_owner of the database.
The default schema of the user "finan" is finan.
The login "finan" is mapped to user "finan".
When the login "finan" has the fixed server rol sysadmin, the following statement:
Select count (*) from cmobjects
returns 600 records.
However, when the login "finan" hasn't the rol sysadmin, the same statement returns 305 records.
Someone can explain this behavior?
Thanks.
October 14, 2015 at 1:45 am
The value of DEFAULT_SCHEMA is ignored if the user is a member of the sysadmin fixed server role. All members of the sysadmin fixed server role have a default schema of dbo even if it is set to something else at another level
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply