PS: What i found in BOL

From: Stefan van den Berg (a@b.hom)
Date: 08/29/02 

From: "Stefan van den Berg" <a@b.hom>
Date: Thu, 29 Aug 2002 17:45:28 +0200

PS: In BOL i found:
<snip>ALTER VIEW permissions default to members of the db_owner and
db_ddladmin fixed database roles, and to the view owner. These permissions
are not transferable. To alter a view, the user must have ALTER VIEW
permission along with SELECT permission on the tables, views, and
table-valued functions being referenced in the view, and EXECUTE permission
on the scalar-valued functions being invoked in the view."</snip>

Problem remains is that i don't know how to grant alter view permissions )-:

Relevant Pages

  • Re: DDL Permissions - CREATE PROCEDURE, but no CREATE TABLE
    ... Sorry, you are correct, I misread the original message. ... if you want this person to use the dbo user. ... > reponse is angled towards data access permissions. ... > to CREATE, ALTER, or DROP tables or other objects. ...
    (microsoft.public.sqlserver.security)
  • Re: permissions resetting on a View
    ... you run the sp_refreshview it appears to keep the permissions on a view. ... If you really want to create or alter a view via a stored procedure you can ... "Terrell Miller" wrote in message ... > delete the view and recreate it? ...
    (microsoft.public.sqlserver.server)
  • Re: How to determine if a user has a permission programmatically?
    ... I need to determine in advance if a user logged on to SQL Server 2005 can ... sp_addrolemember and ALTER LOGIN). ... determine programmatically if a user has specific permissions (ALTER ANY ...
    (microsoft.public.sqlserver.security)
  • Re: The "Best Practice" for securing my vb.net/SQL connection.
    ... Users will not be able to bypass the security built into the end client by using the SP to run select and update statements at will, because they cannot alter the stored procedures. ... If you only give users Execute permissions on stored procedures and no other permissions, I don't really see what they can do to break things. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: "Your system has no paging file"
    ... > Your system has no paging file, or the paging file is too small. ... But, to help, did you alter the permissions on the C: ... Microsoft Windows MVP - Windows Server - Directory Services ...
    (microsoft.public.win2000.dns)