Re: alter view permissions

From: Gabriel (anonymous_at_discussions.microsoft.com)
Date: 03/23/05 

Date: Wed, 23 Mar 2005 04:51:14 -0800

Thanks, I have not mentioned about ability to also create
new views, stored procedures etc. This actions are not
permited with db_datawriter role. Any ideas? :)

>-----Original Message-----
>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
>
>
>.
>

Relevant Pages

  • Re: deny users from accessing server from Management Studio
    ... Through an MS-Access application (with back-end ... SQL 2005), users can select, insert and update. ... them to have the same ability in Management Studio. ... Can you elaborate on what type of stored procedures? ...
    (microsoft.public.sqlserver.security)
  • did debugging with sql server sp3 ever get fixed?
    ... When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures ... SQL Server is on the same machine as Visual Studio? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Simple Best Practice Question
    ... I am unsure how to go about this. ... > In short the answer is Stored Procedures ... edit and delete records or do I use stored procedures?? ... >> Many thanks in advance for any assistance ...
    (microsoft.public.sqlserver.programming)
  • Re: MSSQL vs. SYBASE
    ... > Adding RAISERROR is not an option, we would have to edit 1,000+ stored ... > procs. ... Then you would have to tame ADO. ... 1000 stored procedures in one database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Permissions question...
    ... "Brett Davis" wrote: ... > stored procedures but not table schema. ... > database role but that looks like that will give the developer the ability ...
    (microsoft.public.sqlserver.programming)