Kbase P11682: Error 962 on GRANT
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
** Table <name> does not exist or cannot be accessed. (962)
GRANT SELECT ON <table-name> TO PUBLIC.
CAUSE:
The table <table-name> was created through the Data Dictionary.
FIX:
As written with our "SQL-89 Guide and Reference", within the Collection "Progress SQL/Open Access":
the GRANT and REVOKE statements only work on tables that you created using an SQL CREATE TABLE statement.
When having created a table with the statement CREATE TABLE from within a 4GL program, then you may use the SQL92 statement GRANT. As the 4GL tables are within the schema "PUB", you need to prefix the table-name with "PUB." like in:
GRANT SELECT ON PUB."tableX" TO PUBLIC.