SQL Server 2000 metadata application (2): Obtain the user view of the database

SQL Server 2000 metadata application (2): Obtain the user view of the database

Select   Object_name (ID) As   Object_name , User_name (UID) As   User_name ,
Type As Type, crdate As Date_created
From Sysobjects
Where (Type = N ' V ' ) And ( Permissions (ID) &   4096   <>   0 ) And ( Objectproperty (ID,
N ' Ismsshipped ' ) =   0 )
Order   By   Object_name (ID)