One of our developers is attempting to do an "Insert" into a view. They are connecting in via ODBC.
I gave the user profile *ALL authority to the View but I am getting the error:
Message: [SQL0551] Not authorized to object VSTOWERINT in DCTEST type *FILE. Cause . . . . . : An operation was attempted on object VSTOWERINT in DCTEST type *FILE. This operation cannot be performed without the required authority. Recovery . . . : Obtain the required authority from either the security officer, the object owner, or a user that is authorized to the QIBM_DB_SECADM function. If you are not authorized to a logical file, obtain the authority to the based-on files of the logical file. Try the operation again. Processing ended because the highlighted statement did not complete successfully
I figured I needed to give the user access to the file that the view was based on...but I gave the user *ALL access to this file too and we are still getting the same error.
Does anyone have any insight into why we would be getting this error - even though we gave the user *ALL access?
Thanks in advance