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 |
|
iancuct
Yak Posting Veteran
73 Posts |
 Posted - 2005-12-13 : 12:19:35
|
| I have an application .ADP (access data project) that usses passthrough autentication or windows authentication to connect to SQL server 2000----------------so if user iancun opens the application given he has access to the underlining tables that the application usses he will be able to make changes to it. In SQLServer2000 iancun has access to table "Employee" therefore iancun will be able to add Employees.However Table employee has Update,Insert, and Delete Triggers (audit triggers)This triggers (record changes) and insert the changes in the "Audit Log" tableHowever user Iancun doesn't have Insert,Update and Delete permission on the "Audit Log" table. Therefore I get an error that i don't have permisssion on the "audit log" table.IS there a way that i can have the trigger execute without giving user iancun permissions to the "Logg table" |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-12-13 : 13:26:03
|
| My guess is that either the audit table is in another database or you are using dynamic sql to write to the audit table.With an audit table in the local database and non-dynamic sql you shouldn't need to grant permissions on the audit table to the user.Be One with the OptimizerTG |
 |
|
|
|
|
|
Triggers with/ Permissions