Hi

Is there any way to setup default permissions when creating Database
objects in SQL Server? Pretty much all of our Tables fall under the DB
Role "Viewers" - and I would like this to default with each new
table/view/sp etc that I create. If this is possible I assume you can
default multiple roles? Eg. "Viewers" and "Users"?

Cheers
Donovan


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page