September 7, 2009 at 12:49 am
Need query to find out the list of users who uses our schema... want to identify the list of views in our schema with the list of users in the views
September 7, 2009 at 1:45 am
zelpraveen83 (9/7/2009)
Need query to find out the list of users who uses our schema... want to identify the list of views in our schema with the list of users in the views
dont quite understand the question.
do you use schemas or just dbo. or are you referring to our schema as our objects (tables.procedures etc). can you give an example?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply