SQL Server 2000 元数据应用(二):获得数据库的用户视图
SQL Server 2000 元数据应用(二):获得数据库的用户视图
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)
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)
posted on 2006-10-27 12:45 Clark Chan 阅读(415) 评论(0) 编辑 收藏 举报