| Author |
cannot see the view
|
|
| maxzsim 2005-06-29, 7:23 am |
| 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
| |
| Keith Kratochvil 2005-06-29, 7:23 am |
| 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 TO
UserNameGoesHere
--
Keith
"maxzsim" <maxzsim@discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B- 40A686C1C69D@microso
ft.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
| |
| maxzsim 2005-06-29, 11:23 am |
| 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 TO
> UserNameGoesHere
>
> --
> Keith
>
>
> "maxzsim" <maxzsim@discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B- 40A686C1C69D@microso
ft.com...
>
>
>
| |
| Keith Kratochvil 2005-06-29, 1:23 pm |
| 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@microso
ft.com...[color=darkred]
> 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:
>
| |
| maxzsim 2005-06-29, 8:23 pm |
| 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@microso
ft.com...
>
>
>
|
|
|
|