Sqlexp

[ludi]

Good day

I'm running progress OpenEdge 12.8, I used the following scripts to add users to my database, users are added and can create a connection using SQLEXP, but I can't pull tables as its saying access denial, any assistance?

 

[Patrice Perrot]

Which user are you using to run 'grant select, update, insert,delete on PUB."' + _file._file-name + '" to ~"dario" '

This user should be allow to do it (like Sysprogress)

Patrice

 

[ludi]

even Sysprogress still not working

 

[ludi]

 

[Rob Fitzpatrick]

Your user SQLUser is unable to read data because your attempt to grant it select permissions failed.

First, check who has such permissions; look in the sysdbauth table. E.g.:
select * from sysprogress.sysdbauth;

 

[Rob Fitzpatrick]

This KB may also help:
https://community.progress.com/s/article/20143

 

[ludi]

Thanks all i managed..