How can I ensure a read only user is created for every new database in SQL server 2005?

We create multiple databases in sql server 2005. I would like to make sure that every new database that is created has a specific read only account when it gets created. I know there is a way to write code to do this开发者_如何学Python, but is there a way we can set up a database template of some sort so every time a new database is created the account is automatically added from SQL server side rather than the code side?

If you mean one read-only user account for all databases on a server, you can use this hack:

• Create a new SQL Server login
• Create a new Database user in model database with db_datareader privilegues.

All new databases use the model db as template, so the user will be available in all databases.

But keep the security issues in mind. ;-)