Rainbow Portal

FileName: ChangeObjectOwner.sql

Description: Contains SQL used to change Rainbow database objects owner from '\ASPNET' to 'dbo' or any other user you may want.

The script takes all user defined objects that are owned by user different than 'dbo' and changes its ownership to 'dbo'. (or the target user)

Assumptions:

The script assumes that Rainbow portal is installed with Rainbow as a database name. If the name of the database is different, change the first line of the script. The script assumes that the new user name is 'dbo'. If different user is required, change the 'dbo' name in the script (it must be a valid user in the database).

History: 06/30/2003 -- Marek Kepinski (mkepinski@impaq.com.pl)

Initial implementation.

Notes:

Ignore warning displayed be SQL Server concerning possible breaking of stored procedures due to changes of object owner.

I have found a nice SQL script that may help changing owner on all objects. This is useful if you change your mind and want to go back to SQL auth after playing with integrated security (ASPNET).

SELECT 'EXEC(''sp_changeobjectowner @objname = ''''' + ltrim(u.name) + '.' +

ltrim(s.name) + '''''' + ', @newowner = dbo'')'

FROM sysobjects s, sysusers u

WHERE s.uid = u.uid AND u.name <> 'dbo'AND xtype in ('V', 'P', 'U') AND u.name not like 'INFORMATION%' order by s.name