Re: alter view permissions

From: Uri Dimant (urid_at_iscar.co.il)
Date: 03/23/05 

Date: Wed, 23 Mar 2005 12:58:10 +0200

Hi
Add him to db_datawriter database role but remove him from ddladmin db role

"Gabriel" <anonymous@discussions.microsoft.com> wrote in message
news:125c01c52f94$9b7e2d10$a501280a@phx.gbl...
> Hello,
>
> pls help, how can I remove alter view permission for
> user who is member of ddladmin db role, select and update
> queries shoud remain permited. The user should be able to
> edit all other views, stored procedures etc, except this
> one view.
>
> thank you for help