How to use dbo procedure to execute for different schema?

• phuchy220284

  Valued Member

  Points: 55

  More actions

  August 21, 2014 at 4:10 am

  #310842

  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.