|
> 以View所有者的身份,执行创建View的Select部分,成功,
Good. At least that part is passed. As 老熊 says, the query part of the view needs directly granted privileges. You can simulate this with command "set role none;" and run the query again. If it fails as you saw when you compiled the view, try desc on each table and view referenced in the view query.
Yong Huang |
|