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
put the double quotes around just the table name:
grant select on PUB."CUST$" to <myuser>;
Thanks to all of you who were about to educate me !
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