Error 15814 - is it because of a non-alpha in table name? - Forum - OpenEdge RDBMS - Progress Community

Error 15814 - is it because of a non-alpha in table name?

 Forum

Error 15814 - is it because of a non-alpha in table name?

This question is not answered

Hi -- I'm trying to use sqlexp to do a "grant select on PUB.CUST$ to <myuser>;" but I'm getting error 15814 saying "Table/view/synonym (which is misspelled) not found".

Is it because the filename ends with a "$" ?

I tried putting double quotes around "PUB.CUST$" but it expanded that to "SYSPROGRESS.PUB.CUST$" (which also was not found), and I tried single quotes but that yielded a syntax error message.

Any known workaround for granting permissions on a file/table like this?

oe 11.7 on rhel ent 7

All Replies
  • Hi,

    Try this:    grant select on PUB."CUST$" to <myuser>;

    That should make your Grant work OK.

    The double-quotes have to be around sql identifier with a special character, which in this case is CUST$. When you got PUB and CUST$  then the sql identifier becomes "PUB.CUST$" which is not what you want here.

    Hope this helps,                  ....steve pittman