Reference Manual
   CHAPTER 16. System Views     

SYSPUBLICATIONS system view

CREATE VIEW SYS.SYSPUBLICATIONS
AS 
SELECT(select user_name FROM SYS.SYSUSERPERM AS u
   WHERE u.user_id=p.creator) AS creator,
   publication_name,remarks 
FROM SYS.SYSPUBLICATION AS p

Presents the user name from the SYSUSERPERM table for all creators and displays the publication name and remarks from the SYSPUBLICATION table in a more readable format.