SQL Server Performance Forum – Threads Archive
looking for script to list all the objects1. From instance level, list all the dbs belongs to my account? 2. From database level, list all the database objects belongs to my account? ——————
Yes you can get that information if you can work out with SMO in SQL 2005, refer tohttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=175926&SiteID=1 fyi. 2. You can use SP_HELPROTECT on one database level for a login or list of logins. Kind of answered your own questionhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18440 here. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
I think db objects are owned by schemas not the users any more!!! Mohammed U.