Running an SP as a control grouped user

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!