Hello.
I tried to give the right for creating stored procedure to a user. Even I grant all privileges to my user (all rights are marked in the PCC security property of this user) he is not able to create a SP "your are not authorized ...".

Grant login to Test:test#
Grant all on * to Test#
Grant createSp to Test#
grant createview to Test#
grant all on "Table1" to Test#
..
grant all on "Tablen" to Test#

Michael