The following SELECT statement returns the names of the role creators:
SELECT rolename (char(8)), creatorname (char(8)), commentstring (char(20)), createtimestamp, ExtRole from DBC.RoleinfoV;
Result:
RoleName CreatorName CommentString CreateTimeStamp ExtRole -------- ----------- -------------------- ------------------- ------- r1 u1 Comments on r1 2002-08-13 10:26:19 N r2 u2 Comments on r2 2002-08-13 10:26:25 Y