Kbase P28866: Procedure from Solution 20419 does not work
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
Procedure from Solution 20419 does not work
"select * from sysprogress.systabauth;" does not show the GRANT changes
CAUSE:
The procedure from Solution 20419 is just generating the GRANT commands.
Extracted From Solution 20419: When you execute this CALL statement from the SQL Explorer, disable the option "Table Format" in the View menu so the output can be copied and pasted into the SQL Explorer editor to effectively run the SQL script.
FIX:
Execute the GRANT commands generated by the procedure.