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 |
|
M.E.
Aged Yak Warrior
539 Posts |
 Posted - 2003-01-22 : 12:35:37
|
| I have a little permission problem here.I have a user (UserA) who has permissions granted to update TabA. TabA has a trigger on it ascreate trigger trigAfor update asEXEC ProcASorry if that's incorrect syntax.. trying to type quickly :)Now ProcA goes off and does it's thing... It updates another table. My question is... What security context is that stored proc run in? With UserA's permissions? Or it running in something else because of the trigger?-----------------------SQL isn't just a hobby, It's an addiction |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-01-22 : 13:10:02
|
| It will run with UserA's permissions.Jonathan{0} |
 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2003-01-22 : 15:06:57
|
| I figured as much... Just wanted to confirm... Thanks Jon-----------------------SQL isn't just a hobby, It's an addiction |
|
|
|
|
|
|
Triggers executing stored procs.. permissions?