I have created a stored procedure with user id dbadmin . This user id has the authorization to do update , delete , insert and select against he needed tables. I am granting execute authorization for dbview. But when i am trying to execute a prepare statement that has update in it with parameter marker, in prepare it gives -551 authorization problem. The same for select with prepare has no problems. Other statements like delete , insert ,update without prepare are working fine from dbview id < it is getting the authorization of the stored proc owner> .