SQL Server, creating a view - permissions


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL Server, creating a view - permissions

  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




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


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center