Re: how to give a user permission to modify a view definition

From: Uri Dimant (urid_at_iscar.co.il)
Date: 11/22/05 

Date: Tue, 22 Nov 2005 14:23:33 +0200

Diego
I think the user should be a member db_owner fixed database role. If he/she
is an owner of the view /table so they can modify only their views/tables

"Diego A. Caggiano" <Diego A. Caggiano@discussions.microsoft.com> wrote in
message news:A471E974-CDF0-46BE-8480-676637613D19@microsoft.com...
> Hi,
>
> We need to give a user a permission to modify the definition of a single
> view in an SQL Server 2000 database.
> We do not want to give the user any of the predefined roles(like
> ddladmin),
> because we would be given him more permissions than really needed. Is it
> possible? If so, which sql should we use?
> Thanks in advance,
>
> Diego A. Caggiano

Relevant Pages

  • Re: link table
    ... If SQL Server is set for SELECT permission only on the table then there is ... And your user who can edit data has Guest account privileges with Insert, ... can modify the link table and the changes saved to sql. ...
    (microsoft.public.access.externaldata)
  • link table
    ... I create a useronly have "read" permission in SQL server. ... can modify the link table and the changes saved to sql. ... I think the normal way shouldn't have permission to WRITEtable. ...
    (microsoft.public.access.externaldata)
  • Re: Office 2007 NTFS Permissions problem
    ... Word and Excel 2003 save working COPIES of open files on ... The copies remain OPEN while they're open in Word/Excel. ... That would require modify permission because the file wasn't already ...
    (microsoft.public.office.misc)
  • Re: Applying NTFS Folder Permissions
    ... 2nd paragraph indicates that "Modify" in the first paragraph should have ... which the HR group has been granted the Read permission and the 4th Floor ... Giorgio is attempting to access a folder for which the HR ...
    (microsoft.public.cert.exam.mcsa)
  • Re: Restricting Domain Admins
    ... > Change the security on the adminSDHolder container so that domain admins ... > Modify Permissions ... >>> Removed Modify permission ... >>> Removed modify owner permission ...
    (microsoft.public.windows.server.security)
Quantcast