Kbase 19695: SQL-92: Privileges When Creating Views for Other Owners
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/04/2003 |
|
Solution ID: 19695
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
A SQL-92 view is created by DBA for user B
CREATE VIEW userB.cust (custnum, name) AS
SELECT "cust-num", name from PUB.customer;
User A is granted select priviledge for the view
GRANT SELECT ON userB.cust TO userA
User A logs in and try to run select query for this view
User A gets following error
Access Denied (Authorisation failed)(7512)
CAUSE:
User B does not have SELECT privilege on PUB.customer
FIX:
Log in as DBA and
GRANT SELECT ON PUB.customer TO userB;