CREATE USER [UserB] WITHOUT LOGIN
EXEC sp_addrolemember N'db_datareader', N'UserB'
EXEC sp_addrolemember N'db_datawriter', N'UserB'
EXEC sp_addrolemember N'db_ddladmin', N'UserB'
GRANT EXECUTE TO [UserB]
GRANT CREATE SCHEMA TO [UserB]
GRANT VIEW DEFINITION TO [UserB]

SET NOCOUNT ON
EXEC AS USER = 'UserB'
--WHILE 1=1
BEGIN
DECLARE @name sysname
SELECT  @name = name FROM
(
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')
UNION ALL
SELECT name
FROM sys.objects
WHERE schema_id IN (SELECT schema_id
                    FROM sys.schemas
                    WHERE name = N'dbo')

)T
END
REVERT;