Old School question Progress 9.1d and Vantage 6.1 views

Yahoo Archive
1
Not sure if this helps but my old instructions are slightly different from yours. Using the SQL Explorer tool - Connect:

Then Type:
SET SCHEMA 'ODBC'
and press the execute


Type:
COMMIT
and press the execute

Type:
create view customer_view
as
select * from pub.customer
and press the execute

Type:
COMMIT
and press the execute

exit

--- In vantage@yahoogroups.com, "Mike Lowe" <MLowe@...> wrote:
>
> Ok, trying to create the infamous customer view in a progress database.
> I created this using:
>
>
>
> Create view odbc.customer_view
>
> As
>
> Select * from pub.customer
>
>
>
> This worked, no problem. Can see the data in SQL Explorer when issuing
>
> Select * from odbc.customer_view
>
>
>
> Next, I granted access to this table using
>
>
>
> GRANT SELECT ON odbc.customer_view TO odbcuser;
>
> COMMIT;
>
>
>
> I am able to link this view to an Access database. However, when I try
> to view or query the linked view I get the authorization denied error
> message.
>
>
>
> Have I missed something simple?
>
>
>
> Mike Lowe
>
> Director of I.T.
>
> Connor Manufacturing
>
> Ofc: (503) 465-3904
>
> Cell: (949) 973-7621
>
> Email: MLowe@... <mailto:MLowe@...>
>
> Web: www.ConnorMS.com <http://www.connorms.com/>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Ok, trying to create the infamous customer view in a progress database.
I created this using:



Create view odbc.customer_view

As

Select * from pub.customer



This worked, no problem. Can see the data in SQL Explorer when issuing

Select * from odbc.customer_view



Next, I granted access to this table using



GRANT SELECT ON odbc.customer_view TO odbcuser;

COMMIT;



I am able to link this view to an Access database. However, when I try
to view or query the linked view I get the authorization denied error
message.



Have I missed something simple?



Mike Lowe

Director of I.T.

Connor Manufacturing

Ofc: (503) 465-3904

Cell: (949) 973-7621

Email: MLowe@... <mailto:MLowe@...>

Web: www.ConnorMS.com <http://www.connorms.com/>





[Non-text portions of this message have been removed]