I am trying to give permissions to a contractor so that he can create tables, views, and stored procedures. I assigned the user to the role db_owner, and he can do all that I mentioned above.
The one weird thing is that when the user right-clicks on a view, and selects Script View As --> Create To --> New Query Editor Window, he gets the error, "Select permissions denied on object 'trigger_events', database 'mssqlsystemresource', schema 'sys' (Microsoft SQL Server, Error: 229)"
I have tried "grant select on sys.trigger_events to user" (user's username), and while the statement executes successfully, he still get's the same error.
He does not get this error when he uses the Alter To option.
Can you please help me so that he can use the Create To option?