Microsoft KB Archive/69360

= INF: No Conflicts Between DBO and Aliased DBO in SQL Server =

Article ID: 69360

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q69360



SUMMARY
If an alias has been created between a user in SQL Server and the database owner (DBO) of a database, SQL Server will allow both the original DBO and the aliased DBO to access the database at the same time.



Example
 Create a user called CANOE with the password &quot;paddle.&quot; Grant ALL privileges to CANOE. Log onto SQL Server via ISQL with the username CANOE. This will be referred to as Screen Group A. Create a database called WATER and execute a USE WATER command to position the user CANOE into the WATER database. Open a second screen group and log onto SQL Server as the user sa (system administrator) via SQL Administrator and create another user named CROSS with the password &quot;country.&quot; Using SQL Administrator assign the user CROSS the alias of DBO for the WATER database.  Open a third screen group, log onto SQL Server via ISQL, and execute a USE WATER command to position the user CROSS into the WATER database. This will be referred to as Screen Group B. At this point, the user CANOE, which is the DBO of the WATER database, is logged onto WATER. Also, the user CROSS, which is the aliased DBO of the WATER database, is logged onto WATER.

<pre class="fixed_text">       Screen Group           Screen Group A                      B        ___________             ___________ |          |           |           |       |  canoe    |           |  cross    | | userid   |           |  userid   | |___________|          |___________|            |                        |              |                    |                |   Database     | ______________                |              |                 |    water     | |             |                 |______________|

</li> Switching back and forth between the two Screen Groups A and B, create tables and insert values. There will not be any conflicts.</li></ol>

Additional query words: Security and permissions

Keywords: kbother KB69360

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.