Why Can't I Query a View After I'm Granted the Select Table Permission on the View?
Symptom
User A created Table1.
User B created View1 based on Table1.
After the Select Table permission on Table1 is granted to user C, user C fails to query View1.
Possible Causes
User B does not have the Select Table permission on Table1.
Solution
Grant the Select Table permission on Table1 to user B. Then, query View1 as user C again.
O&M Guide FAQs
- Why Does My Account Have Insufficient Permissions Due to Arrears?
- Why Does the System Display a Message Indicating Insufficient Permissions When I Update a Program Package?
- Why Is Error "DLI.0003: Permission denied for resource..." Reported When I Run a SQL Statement?
- Why Can't I Query Table Data After I've Been Granted Table Permissions?
- Will an Error Be Reported if the Inherited Permissions Are Regranted to a Table That Inherits Database Permissions?
- Why Can't I Query a View After I'm Granted the Select Table Permission on the View?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
more