Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to use dbo procedure to execute for different schema? Expand / Collapse
Author
Message
Posted Thursday, August 21, 2014 4:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 12:39 PM
Points: 1, Visits: 29
I am using SQL Server 2008 R2, I have a schema [dbo], and in that schema, I have created a stored procedure dbo.GetAccount:

Create procedure dbo.GetAccount
As
Begin
Select * from tblAccountNet
End

Then, I have created a schema [ABC] with user named UserABC.

Now, I would like to login with UserABC and execute dbo.GetAccount for schema [ABC] to get all user of it and don't want to change code of dbo.GetAccount. So, how can I do?

Thanks for your help.
Post #1605729
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse