|
|
|
Re: error 04063 creating view [message #652508 is a reply to message #652497] |
Fri, 10 June 2016 17:31 |
|
Barbara Boehmer
Messages: 9090 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
There are a lot of possibilities. A common problem is that, likes procedures and functions, privileges granted through roles do not apply to views. So, a query might run fine with some role privileges, but the same query in a view would not execute, because the privileges need to be granted explicitly, not through a role. To test if this is the problem, you can try SET ROLE NONE and then see if the query by itself still executes If not, then that is the problem. If you created the view using force, you should also remove the force keyword to see what errors that produces or if the view can even be created.
|
|
|