select  distinct
	db_name()			as TABLE_CATALOG
	,user_name(o.uid)	as TABLE_SCHEMA
	,o.name				as TABLE_NAME
	,case o.xtype
		when 'U' then 'BASE TABLE'
		when 'V' then 'VIEW'
	end					as TABLE_TYPE
from
	sysobjects o
where
	o.xtype in ('U', 'V') and
	permissions(o.id) != 0select  distinct
	db_name()			as TABLE_CATALOG
	,user_name(o.uid)	as TABLE_SCHEMA
	,o.name				as TABLE_NAME
	,case o.xtype
		when 'U' then 'BASE TABLE'
		when 'V' then 'VIEW'
	end					as TABLE_TYPE
from
	sysobjects o
where
	o.xtype in ('U', 'V') and
	permissions(o.id) !=  0