Chapter 16 System Views
1065
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.
To Next Page
Loading...