SQL Permissions


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL Permissions

  1. #1
    ian Guest

    SQL Permissions


    Is there any way of determining what SQL permissions are required to execute
    a stored proc. I don't care if I use another stored proc an extended stored
    proc or an API call I just want to know if it is possible.

    Cheers
    Ian
    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: SQL Permissions

    I'm not sure I understand the question? The only permission generally
    required to execute a stored proc is the EXEC right on that sproc. The
    access to tables and other objects referenced by the sproc is implied by the
    fact that you granted permission to run the sproc.

    For example, Bob may not have any rights at all to TableA
    Bob can have EXEC rights to spInsertTableA - which inserts a record into
    TableA

    In this mix, Bob couldn't insert a record into TableA using a direct INSERT
    statement, but he could call spInsertTableA to insert the record (INSERT
    authority is implied as along as it is within the scope of the sproc).


    --
    Rob Vieira MCSD, MCT, MCDBA
    www.ProfessionalSQL.com

    "ian" <iang@intervate.com> wrote in message news:3a6e8a8c$1@news.devx.com...
    >
    > Is there any way of determining what SQL permissions are required to

    execute
    > a stored proc. I don't care if I use another stored proc an extended

    stored
    > proc or an API call I just want to know if it is possible.
    >
    > Cheers
    > Ian



    Share on Google+

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