Kbase P4296: How to deploy SQL92 privileges
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to deploy SQL92 privileges
FACT(s) (Environment):
Progress 9.x
FIX:
1) Create a file (.SQL) containing the SQL query:
GRANT SELECT ON PUB.<table> TO PUBLIC;
COMMIT;
2) Run the SQL Explorer tool in batch:
sqlexp -char -infile grant.sql -outfile error.txt -db <db name> -S <port number> -H <host name> -user <user name> -password < password>
Any errors processing these commands will be located in the file error.txt.