All Questions
2 questions
10
votes
2
answers
17k
views
Permissions on Trigger Problem
I am working with a database in MS-SQL 2008 R2, and I'm running into a problem.
The basic setup is this: There are two tables of interest: dbo.Assesments and audit.Assesments. dbo.Assesments is the ...
- 203
3
votes
2
answers
3k
views
DDL trigger permission Error
I have a two users, user1 and user2.
User1 has sysadmin rights and I have created a database level trigger through sa.
Now I am trying to create a table through user2 who has db-ddladmin rights and ...
- 53