Luis,

It seems the security set up is not using consistent account to connect to
the database to be linked. How is the linked server security setup? Is it
a Oracle linked server? You should be able to get the information in the
property window under security tab.

Thanks.

Sang Nahm

-----Original Message-----
From: Luís Ganhão [mailto:luis.[Email Address Removed] Tuesday, May 28, 2002 8:12 AM
To: '[Email Address Removed] Linked Servers


Hi all,

I have a problem with linked servers.

When I log with a Windows Account (without any privilege), I can see the
tables in the linked server.

But when I log with a SQL Account (with all kind off privileges), I can´t
see the tables in the linked server.

Probably it´s a very simple problem, but I work with Oracle and couldn't see
anything about that.

TIA,

Luís Manuel Martins Ganhão
Novabase, Desenvolvimento à Medida
Serviços de Valor Acrescentado
DBA Oracle Certified Professional 8i
Av. Engº Duarte Pacheco, Torre 1 - 9º
1099-078 Lisboa
Tel: 351213836300
Tlm +351967610858
http://novabase.pt
CONFIDENCIALIDADE: Este e-mail é confidencial e apenas pode ser lido,
copiado ou utilizado pelo destinatário. Se o recebeu por engano, por favor
contacte o remetente através de e-mail ou pelo telefone + 351 21 383 63 00.
Agradecemos ainda que apague este e-mail e não divulgue o respectivo
conteúdo.
CONFIDENTIALITY: This e-mail is confidential and may be privileged. It may
be read, copied and used only by the intended recipient. If you have
received it in error, please contact the sender immediately by return e-mail
or by phoning + 351 21 383 63 00. Then please delete this e-mail and do not
disclose its contents to any person.

MS Sql Server LazyDBA home page