+ Reply to Thread
Results 1 to 3 of 3
  1. Junior Member Registered Member
    Join Date
    Jun 2010
    Posts
    7

    Certifications
    MCTS Sharepoint 2007 Config, MCTS Vista Config, ITIL v3 Foundation
    #1

    Default Stored Procedure question

    Hello everyone,

    I have a question on running a stored procedure:

    If you have a user running a stored procedure on a table on schema .dbo and the stored procedure will not run with an error of user not having "x" permission on the particular table:

    Do you give the specific user whatever permissions are needed to perform actions on the table or run the stored procedure as another user with proper permissions? Would you ever run as .dbo (would that even work?)?

    This is a paraphrased question I've seen on a practice exam and cannot seem to find an explanation for the answer. Many thanks!
    Reply With Quote Quote  

  2. SS -->
  3. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #2
    If you are forcing CRUD ops to be done via a stored procedure you would probably not want to grant permissions directly on the table for anything other than read. Here is an article that will help:

    Granting permission with the EXECUTE AS command in SQL Server 2005
    Reply With Quote Quote  

  4. Junior Member Registered Member
    Join Date
    Jun 2010
    Posts
    7

    Certifications
    MCTS Sharepoint 2007 Config, MCTS Vista Config, ITIL v3 Foundation
    #3
    This is exactly what I've been looking for. Much appreciated!
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks