|
Home > Archive > MS SQL Server > June 2005 > not able to see Views
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
not able to see Views
|
|
| maxzsim 2005-06-30, 7:23 am |
| Hi ,
i have set up odbc database source --> OD1 to connect to SERVER1 , from
crystal report i have used OD1 to connect to SERVER1 --> DB1 however , i
could not see the views but only the tables , stored procedures
when i create the same view in SERVER1 --> DB2 and i used OD2 to connect
from crystal report , i could see the tables , views & stored procedures
i believe it's some permission over at SQL end , could anyone advise ?
i have tried to use the GRANT permission on the user as advised earlierbut
still no good
tks & rdgs
| |
| John Bell 2005-06-30, 7:23 am |
| Hi
You may want to use Query Analyser to connect to each of the servers.
Check out sp_helprotect and also sp_helpuser, sp_helplogins and sp_helpgroup
to see if there are any differences. More information on these is in Books
Online.
John
"maxzsim" wrote:
> Hi ,
> i have set up odbc database source --> OD1 to connect to SERVER1 , from
> crystal report i have used OD1 to connect to SERVER1 --> DB1 however , i
> could not see the views but only the tables , stored procedures
>
> when i create the same view in SERVER1 --> DB2 and i used OD2 to connect
> from crystal report , i could see the tables , views & stored procedures
>
> i believe it's some permission over at SQL end , could anyone advise ?
> i have tried to use the GRANT permission on the user as advised earlierbut
> still no good
>
> tks & rdgs
|
|
|
|
|