cannot see the view

Hi ,
I have created a login id on 2 different databases DB_A & DB_B as the owner
from crystal report i can see the view of DB_A but not DB_B using the same
login id
Could anyone kindly advise ?
tks & rdgsYour post is not clear.
What is the default database for the login? Is Crystal connecting to DB_A?
If so it will be able to see the view in that database. Unless you "tell"
Crystal to look within DB_B for the view it will not be found.
Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
UserNameGoesHere
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> Hi ,
> I have created a login id on 2 different databases DB_A & DB_B as the
> owner
> from crystal report i can see the view of DB_A but not DB_B using the
> same
> login id
> Could anyone kindly advise ?
> tks & rdgs|||Hi Keith ,
the default db for the login is master. and i have set up 2 odbc
datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
from crystal when connecting using DS_A it can show me the view but not when
using DS_B
i hope this time i am clearer in my explanation
i'll try to use the grant select on the view for that login in DB_B
tks & rdgs
"Keith Kratochvil" wrote:

> Your post is not clear.
> What is the default database for the login? Is Crystal connecting to DB_A
?
> If so it will be able to see the view in that database. Unless you "tell"
> Crystal to look within DB_B for the view it will not be found.
> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere T
O
> UserNameGoesHere
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
>
>|||Does Crystal "know" that the other view exists within the other database?
Can you tell it to look in the other database for the view? Sorry, I have
not used Crystal since version 5.
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...[vbcol=seagreen]
> Hi Keith ,
> the default db for the login is master. and i have set up 2 odbc
> datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> from crystal when connecting using DS_A it can show me the view but not
> when
> using DS_B
> i hope this time i am clearer in my explanation
> i'll try to use the grant select on the view for that login in DB_B
> tks & rdgs
> "Keith Kratochvil" wrote:
>|||no worries Keith , tks for all the help given
Cheers,
maxzsim
"Keith Kratochvil" wrote:

> Does Crystal "know" that the other view exists within the other database?
> Can you tell it to look in the other database for the view? Sorry, I have
> not used Crystal since version 5.
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
>
>