Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vi1992
Starting Member
1 Post |
 Posted - 2014-08-22 : 06:40:08
|
| I am using SQL Server 2008 R2, I have a schema [dbo], and in that schema, I have created a stored procedure dbo.GetAccount:SELECT * FROM tblAccountThen, 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. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-22 : 07:53:32
|
| Set ABC to be the default schema for UserABC |
 |
|
|
|
|
|
How to use dbo procedure to execute for different