tag:blogger.com,1999:blog-13265058.post2678952446301215165..comments2009-11-13T21:27:30.946+11:00Gary Myershttps://profiles.google.com/116132019768637593422noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-13265058.post-82395831579595229342009-11-13T21:27:30.946+11:002009-11-13T21:27:30.946+11:00Sorry, my question has been caused by my overlooking the create procedure privilege lack on my development schema.YAPhttp://www.blogger.com/profile/14781383870484872725noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-62306179786097976002009-11-13T06:53:55.210+11:002009-11-13T06:53:55.210+11:00The devuser is only used for password authentication. When they connect as a proxy user to the schema account they will get all the privileges of that schema account.<br /><br />Just think of it as a way to have multiple, individual passwords for the same account.Gary Myershttp://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-73252736557732808332009-11-12T23:27:36.503+11:002009-11-12T23:27:36.503+11:00Typical developers recompile schema objects such as package. What kind of privileges they must have?YAPhttp://www.blogger.com/profile/14781383870484872725noreply@blogger.com