Kbase 34296: How to deploy SQL-92 privileges
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P4296
GOAL:
How to deploy SQL-92 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>
If any error occurs, it will be located in the file error.txt.