Kbase P147027: How to remove a GRANT (SQL) for a GRANTEE that has a control character in or at the end of the name?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/18/2009 |
|
Status: Unverified
GOAL:
How to remove a GRANT (SQL) for a GRANTEE that has a control character in or at the end of the name?
GOAL:
How to remove a GRANTEE who's name has ^J (ascii 10) at the end?
FACT(s) (Environment):
OpenEdge 10.1B
HP-UX
CAUSE:
When adding a GRANT sqlexplorer doesn't complain if the user don't exists. Something like that on UNIX:
SQLExplorer>grant select on pub.test to testuser (return)
1> ; (return)
will add a grant to SYSTABAUTH with a control character at the end of the user name testuser
FIX:
It is not possible to create a user who has control characters at the end of the name so this GRANTEE entry will not be usefully for anyone. You can remove this GRANTEE entry in SYSTABAUTH by creating a sql file which contains a revoke statement for the specific right for the GRANTEE with the same control character in or after the name and then execute this with the "-infile" argument of sqlexp.