erikkl2000
Programmer
I have a linked server to my remote hosting company and when query tables that are in the dbo. schemas i get the expected results. However, when i query with one of my schemas (Person.Table.Column) i get a permission error.
==========================================================
--Error--
Msg 7314, Level 16, State 1, Line 7
The OLE DB provider "SQLNCLI" for linked server "DISCOUNTASP" does not contain the table ""SQL2005_xxxxxxx_xxxxxxx"."Person"."utbAlbums"". The table either does not exist or the current user does not have permissions on that table.
===========================================================
---I have also do this-------------------
GRANT SELECT ON SCHEMA :: Person
TO
[SQL2005_123456_userName_user]
==========================================================
I still get the error
Anyone have any suggestion?
erik
==========================================================
--Error--
Msg 7314, Level 16, State 1, Line 7
The OLE DB provider "SQLNCLI" for linked server "DISCOUNTASP" does not contain the table ""SQL2005_xxxxxxx_xxxxxxx"."Person"."utbAlbums"". The table either does not exist or the current user does not have permissions on that table.
===========================================================
---I have also do this-------------------
GRANT SELECT ON SCHEMA :: Person
TO
[SQL2005_123456_userName_user]
==========================================================
I still get the error
Anyone have any suggestion?
erik