dbo permissions

Hi!
is there a way to revoke "alter table" permission to db_owner role?
Thanks, in advance!According to books on-line, you cannot change privileges of the fixed
database roles.
If possible, can you move the user to a user-defined database role with all
object privileges granted? This what we do in our shop. This will
eliminate the possibility that objects cannot be altered, dropped or created
on the fly..
"Francisco Castillo" <anonymous@.discussions.microsoft.com> wrote in message
news:2DC252B0-5755-4621-91E5-590D6644A30E@.microsoft.com...
> Hi!
> is there a way to revoke "alter table" permission to db_owner role?
> Thanks, in advance!|||Hi,
I suggest you to assign the user the below database roles,
db_datareader
db_datawriter
after that give him the below previlages using a single grant command;
grant create procedure,create table,create view,create function to <User
name>
Thanks
Hari
MCDBA
"Eddy White" <1sg@.onewest.net> wrote in message
news:#fwdo24FEHA.2768@.tk2msftngp13.phx.gbl...
> According to books on-line, you cannot change privileges of the fixed
> database roles.
> If possible, can you move the user to a user-defined database role with
all
> object privileges granted? This what we do in our shop. This will
> eliminate the possibility that objects cannot be altered, dropped or
created
> on the fly..
> "Francisco Castillo" <anonymous@.discussions.microsoft.com> wrote in
message
> news:2DC252B0-5755-4621-91E5-590D6644A30E@.microsoft.com...
>