generate script for adding user in database and datareader member

readonly_all_db.sql

DECLARE @dbname VARCHAR(50)
DECLARE @statement NVARCHAR(max)
DECLARE db_cursor CURSOR

LOCAL FAST_FORWARD
FOR SELECT name FROM MASTER.dbo.sysdatabases OPEN db_cursor
    FETCH NEXT FROM db_cursor INTO @dbname 
WHILE @@FETCH_STATUS = 0
BEGIN
    SELECT @statement = 'use ['+@dbname+']; '+'CREATE USER [monitoring] FOR LOGIN [monitoring];';
	print @statement
    
	SELECT @statement = 'use ['+@dbname+']; '+'EXEC sp_addrolemember N''db_datareader'', N''monitoring'';';
    print @statement
    
	FETCH NEXT FROM db_cursor INTO @dbname
END