Template Script: Schema\Alter authorization to defaults.sql

DECLARE @SQL VARCHAR(MAX)
SELECT @SQL = Util.dbo.StringConcat( 'BEGIN TRY
USE '
 + NAME + '
ALTER AUTHORIZATION ON SCHEMA::[db_accessadmin] TO [db_accessadmin]

ALTER AUTHORIZATION ON SCHEMA::[db_backupoperator] TO [db_backupoperator]

ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [db_datareader]

ALTER AUTHORIZATION ON SCHEMA::[db_datawriter]  TO [db_datawriter]

ALTER AUTHORIZATION ON SCHEMA::[db_ddladmin]  TO [db_ddladmin]

ALTER AUTHORIZATION ON SCHEMA::[db_denydatareader] TO [db_denydatareader]

ALTER AUTHORIZATION ON SCHEMA::[db_denydatawriter] TO [db_denydatawriter]

ALTER AUTHORIZATION ON SCHEMA::[db_owner]  TO [db_owner]

ALTER AUTHORIZATION ON SCHEMA::[db_securityadmin]  TO [db_securityadmin]

ALTER AUTHORIZATION ON SCHEMA::[dbo]  TO [dbo]

ALTER AUTHORIZATION ON SCHEMA::[guest] TO [guest]

ALTER AUTHORIZATION ON SCHEMA::[INFORMATION_SCHEMA]  TO [INFORMATION_SCHEMA]

ALTER AUTHORIZATION ON SCHEMA::[sys]  TO [sys]
END TRY
BEGIN CATCH
END CATCH
'
, '') FROM sys.databases
EXEC (@SQL )

Description for Template Script: Schema\Alter authorization to defaults.sql

Todo
Site Map | Printable View | © 2008 - 2012 NuRoN Consulting, INC | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund
Share This Using Popular Bookmarking Services