• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 16 views
  • Users 0 members are here
Related

Running an SP as a control grouped user

Levi Sauerbrei
$organization

Greetings all,

In Management Studio, is there a way for me to execute a stored procedure as if I were a member of a particular user group?  I'm trying to troubleshoot a custom report but running the SP under my login returns data for all control groups.  Is there a way around this?

Parents
  • $organization

    All in a day’s work.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, November 16, 2010 1:59 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Running an SP as a control grouped user

     

    Caught that (thank goodness for syntax highlighting!)

    I will also give you this year's award for longest description of a single ANSI character. :)

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 11/16/2010 12:30:12 PM

    No problem.  Note that those single quotes have been “MS’d”…(no longer the standard ANSI single quote).  You’ll have to re-munge them back to the “stiff as a board single quote” instead of the “curl towards the text variety”.

     

    :P

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, November 16, 2010 1:19 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Running an SP as a control grouped user

     

    Awesome!  Thanks Ryan.

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 11/16/2010 12:15:12 PM

    In the query window, before you execute the stored procedure, execute this:

     

    Execute AP_SET_CONTEXT ‘ug’, ‘usergroupID’

     

    Where “usergroupID” is the 8 letter ID from T_METUSERGROUP (or the first column of the relevant group in the Security window, like “BoxOffce”).  Anything you execute after this in the same connection/session will utilize control group security.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, November 16, 2010 1:09 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Running an SP as a control grouped user

     

    Greetings all,

    In Management Studio, is there a way for me to execute a stored procedure as if I were a member of a particular user group?  I'm trying to troubleshoot a custom report but running the SP under my login returns data for all control groups.  Is there a way around this?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    All in a day’s work.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, November 16, 2010 1:59 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Running an SP as a control grouped user

     

    Caught that (thank goodness for syntax highlighting!)

    I will also give you this year's award for longest description of a single ANSI character. :)

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 11/16/2010 12:30:12 PM

    No problem.  Note that those single quotes have been “MS’d”…(no longer the standard ANSI single quote).  You’ll have to re-munge them back to the “stiff as a board single quote” instead of the “curl towards the text variety”.

     

    :P

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, November 16, 2010 1:19 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Running an SP as a control grouped user

     

    Awesome!  Thanks Ryan.

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 11/16/2010 12:15:12 PM

    In the query window, before you execute the stored procedure, execute this:

     

    Execute AP_SET_CONTEXT ‘ug’, ‘usergroupID’

     

    Where “usergroupID” is the 8 letter ID from T_METUSERGROUP (or the first column of the relevant group in the Security window, like “BoxOffce”).  Anything you execute after this in the same connection/session will utilize control group security.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, November 16, 2010 1:09 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Running an SP as a control grouped user

     

    Greetings all,

    In Management Studio, is there a way for me to execute a stored procedure as if I were a member of a particular user group?  I'm trying to troubleshoot a custom report but running the SP under my login returns data for all control groups.  Is there a way around this?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data