Kbase P67644: Error 7512 accessing a SQL-92 view - grant user sufficient priviledges
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/19/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
Error 7512 accessing a SQL-92 view
Access denied(Authorization failed) (7512)
CAUSE:
The user that is trying to access the view does not have sufficient privilege
FIX:
Grant the user sufficient privilege.
1) The user has to have select permission on the view itself.
"grant select on <owner>.<viewname> to <username>".
It is not enough (and not required) to have permission on tables included in the view definition.
2) Owner of the view (if explicitly defined in "create view <owner>.<viewname>") has to have select permission on all tables included in the view definition.
For example, if you create a view with statement "create view user1.myview as select * from table1, table2", "user1" is the owner of the view. If you want "user2" to be able to query this view, you have to grant privileges as follows:
grant select on myview to user2;
grant select on table1 to user1;
grant select on table2 to user1;
commit;