model db owner

I have a request to add a user to the model db dbo group.
Can you provide pros/cons to this request
thanks again"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again
Pro:
That user will be created in any new databases you create.
Con:
That user will be created in any new databases you create.|||What they're asking is for someone to have dbo access to every database ever
created in that server. I suppose if the user is the CEO that might be
justified but that's a lot of privileged access to give to anyone.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again|||"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ACF4C5D7-F192-4B68-B05D-B1BF5D951204@.microsoft.com...
> What they're asking is for someone to have dbo access to every database
> ever created in that server. I suppose if the user is the CEO that might
> be justified but that's a lot of privileged access to give to anyone.
>
Oops, missed the dbo part. That's probably not a good idea.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "stoney" <stoney@.discussions.microsoft.com> wrote in message
> news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>>I have a request to add a user to the model db dbo group.
>> Can you provide pros/cons to this request
>> thanks again
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com