Sql privilege

[casorohi]

Hi all

When I refreshed/restore Dev DBs from other DB, it refreshes all data as well as user. To make the user as old I copy the .d from _user table but I always lost the SQL privilege of these 4GL user.
Which vst store SQL privilege ???
Progress Version 10.2B

Thanks

 

[cj_brandt]

sysprogress.sysdbauth

select * from sysprogress.sysdbauth;

 

[TomBascom]

Usually the permissions were granted with a sql script and they can be re-applied by running that script.

 

[tamhas]

I seem to recall that there is script in the bin directory for dumping this stuff ... no Progress at the moment on the current box, so I can't easily go look up the name, but I think it was fairly apparent.

 

[LarryD]

See kbase entry ID: P17829
Title: "How to dump SQL-92 privileges"

 

[casorohi]

Thanks all for your help