This is my first attempt to write a stored procedure in Teradata. I am getting an authorization error:
The user does not have CREATE PROCEDURE access to database pmehrotr
Did you check dbc.allrights table?
Q1: of course. CREATE PROCEDURE is not part of the default rights granted to a user, it must be granted explicitly by the DBA.
Q2: of course not. There are seperate rights for all CREATEs
Q3: yes, typically a few kilobytes (but skewed)