Error while granting a select permission on Selective Column of a table

[casorohi]

Hi All
I am getting error while granting a select permission on Selective Column of a table on following cmd:

GRANT SELECT ON PUB."order" ( order_id, ord_date) to ‘user’;
GRANT SELECT ON PUB.order ( order_id, ord_date) to ‘user’;
GRANT SELECT ON PUB.order ( “order_id”, “ord_date”) to ‘user’;

Is anything I am missing

error:

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210056
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "( order_id ) to user" (10713)

thanks

 

[Stefan]

Judging by the syntax description on page 38 of the manual (http://documentation.progress.com/output/OpenEdge102b/pdfs/dmsrf/dmsrf.pdf) it would seem that you can only specify columns when granting update rights.

If you want to provide specific columns I think you will need to create a view with only those columns and give select rights on the view.

 

[casorohi]

Thanks for clearing this means Its only work for “update” not for select/insert/delete

 

[TomBascom]

Your quoting also looks wrong. Try:

GRANT SELECT ON PUB."order" ( "order_id", "ord_date") to ‘user’;

(SQL does not like "-" and "_".)

 

[casorohi]

Hi Tom
It’s not working .. I tried this with different combination