Post reply

Table Qualification

  • July 15, 2004 at 3:22 pm

    #180965

    Is there any way to set up a User in SQL Server so they DO NOT have to qualify a table name with the owner name in a Select statement?

  • July 16, 2004 at 9:50 am

    #514898

    Make sure all objects are owned by the database owner (dbo).  If the logon ID associated with the current connection doesn't own the table in the Select statement, SQL Server defaults to looking for the table owned by dbo.  That means that the table doesn't need to be qualified with the owner name.

    Greg

     

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply