SQLServerCentral / Discuss Content Posted by Santveer Singh / Article Discussions / Article Discussions by Author / Finding Objects Owned by non-DBO Users / Latest Posts

RE: Finding Objects Owned by non-DBO Users

Najm Hashmi — Thu, 15 Dec 2005 07:08:00 GMT

It is a usefull Script; however, I will avoid the cursor.

RE: Finding Objects Owned by non-DBO Users

santveer — Thu, 16 Dec 2004 05:03:00 GMT

I didn't include DELETE FROM [ObjList] becuase I want to maintain the history also. If some one don't want to maintain the history, he/she may include the DELETE statement. This is just a concept and we can use it in different ways.

Thanks a lot for your time.

RE: Finding Objects Owned by non-DBO Users

santveer — Thu, 16 Dec 2004 04:56:00 GMT

Mike,

Thanks for the suggestion.

Santveer

RE: Finding Objects Owned by non-DBO Users

CDJorg — Wed, 15 Dec 2004 08:52:00 GMT

Definitely a handy script. Although the developers in my company all have dbo privileges to the development database, our Windows Group login is mapped to a user other than dbo. We are forever creating procedures without specifying the [dbo]. in [dbo].[<procedurename>] and ending up owning the procedure instead of dbo.

I would make one enhancement to the script. Right after the SET NOCOUNT ON line, I would add this line:

DELETE FROM [ObjList]

to prevent duplicates from a previous execution from appearing in the table

RE: Finding Objects Owned by non-DBO Users

Mike Schmidt — Wed, 15 Dec 2004 08:30:00 GMT

Very handy script.

Note: I have a few databases with spaces in the name of the database. This frequently trips up scripts but yours is easy to enhance for such a situation. Simply change below line:

, SU.name,SO.name from '+@dbname+'.dbo.sysobjects SO join '+@dbname+'.dbo.sysusers SU

to:

, SU.name,SO.name from ['+@dbname+'].dbo.sysobjects SO join ['+@dbname+'].dbo.sysusers SU

Thanks for sharing your code.

-Mike

Finding Objects Owned by non-DBO Users

santveer — Fri, 05 Nov 2004 15:43:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/