Kbase P62220: Granting permissions for tables accessed via the Merant 3.7
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/15/2004 |
|
Status: Unverified
GOAL:
Granting permissions for tables accessed via the Merant 3.7 ODBC driver
FACT(s) (Environment):
Progress 9.1B
FIX:
The Merant 3.7 driver uses the SQL89 engine.
Granting and revoking permissions via SQL89 is possible for
tables created with the SQL89 engine. There a small tested example:
CREATE TABLE Cust_Table (Cust_Num INTEGER NOT NULL,
Name CHARACTER (30),
Address CHARACTER (30),
City CHARACTER (15),
State CHARACTER (2),
Phone CHARACTER (10),
Credit_Limit DECIMAL (6),
Balance DECIMAL (6),
UNIQUE (Cust_Num) ).
GRANT SELECT ON Cust_Table TO pub .
Please see the SQL-89 Guide and reference for more detailed
explanations.
For tables created using the Progress Data Dictionary or from loaded
definitions via the Progress Data Administration tool the permission can
only be set or changed via the Progress Data Administration tool.