Invalid Object Name

I have a database from a client that I am trying to restore. I am
restoring it when logged in as the user 'PDBA'. The client alos has a
user on the database called 'PDBA' and 'PDBA' is the owner o the
tables when I finish restoring the database.
The problem is when I execute 'SELECT * FROM TABLE_A' I get back the
'Invalid Object Name' error. When I execute it as 'SELECT * FROM
PDBA.TABLE_A' it works fine and I get the results.
I am trying to run this from an application which uses the first SQL
without the PDBA reference and I cannot chnage the application.
Is there a way for me to correct this?
Is there a script I need to run?
TIA
SteveRead about sp_change_users_login in Books Online and make sure that you
operate as the PDBA user name. And, let the developers know that it is
recommended to always owner-qualify object names.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Steve" <seytonjones@.hotmail.com> wrote in message
news:89f27d82.0403110836.56e5837d@.posting.google.com...
> I have a database from a client that I am trying to restore. I am
> restoring it when logged in as the user 'PDBA'. The client alos has a
> user on the database called 'PDBA' and 'PDBA' is the owner o the
> tables when I finish restoring the database.
> The problem is when I execute 'SELECT * FROM TABLE_A' I get back the
> 'Invalid Object Name' error. When I execute it as 'SELECT * FROM
> PDBA.TABLE_A' it works fine and I get the results.
> I am trying to run this from an application which uses the first SQL
> without the PDBA reference and I cannot chnage the application.
> Is there a way for me to correct this?
> Is there a script I need to run?
>
> TIA
>
> Steve