Thanks for the reply that has completed successfully. I will report back when the trigger runs and whether it works.

Cheers,

Morning all,

I have looked into doing what you guys have recommended but being a novice in SQL I haven't been able to do any of them 🙁 embarressing (creating tables...

SpringTownDBA (11/30/2011)

---

Swagger187 (11/30/2011)

---

Gianluca Sartori (11/25/2011)

---

Permissions don't "get lost", but may be revoked by something:

1) Explicit REVOKE commands

2) Drop / re-create view

Personally, I would investigate the drop/re-create as the most likely...

Gianluca Sartori (11/25/2011)

---

Permissions don't "get lost", but may be revoked by something:

1) Explicit REVOKE commands

2) Drop / re-create view

Personally, I would investigate the drop/re-create as the most likely cause, then...

Ok brilliant thanks for your reply. I will have a look into this and report back.