DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Michael Guest

    SQL Server, creating a view - permissions


    Question: Can a user who has CREATE VIEW in a database create views under
    a different id? Eg User ABC creating a view called DBO.REPORT1.

    Your reply would be very much appreciated.

    Michael

  2. #2
    David Satz Guest

    Re: SQL Server, creating a view - permissions

    no, they would need to be db_owner or the like.
    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions

    "Michael" <michaela1920@hotmail.com> wrote in message
    news:3ee6b9f4$1@tnews.web.devx.com...
    >
    > Question: Can a user who has CREATE VIEW in a database create views under
    > a different id? Eg User ABC creating a view called DBO.REPORT1.
    >
    > Your reply would be very much appreciated.
    >
    > Michael




Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links