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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2008-03-20 : 17:43:13
|
| I have a stored procedure that inserts into the Employee tableand my user has EXEC rights to this stored procedure.On the employee table there is a trigger that when a new employee is added it updates Address table.Do I need to grant this user permissions to that Address table?Does he need more permissions on the Employee table?Thanks for your helpR/P |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-20 : 21:57:33
|
| The user must have update permission on the Address table. He doesn't need more permissions on the Employee table since it's happening from a stored procedure. The trigger executes outsides of the stored procedure, which is why additional permissions are needed.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2008-03-21 : 11:39:12
|
| Thank you for your help.R/P |
|
|
|
|
|
|
Triggers and Permissions