The instance hosts multiple databases for different clients. Because of a privacy policy, other clients should not be able to view the other databases except their own.

In the example above,...

Andrew Watson-478275 (2/9/2010)

---

If you check DENY in BOL, it says

which is why...

Jaime I (2/8/2010)

---

Gagne (2/5/2010)

---

I really don't know much on database security and permissions but while reading your post I wondered if adding user2 to the db_owner role is enough, I...

Gagne (2/5/2010)

---

I really don't know much on database security and permissions but while reading your post I wondered if adding user2 to the db_owner role is enough, I would try...