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
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