I am setting up a new sql server and I'm taking the opportunity to review all security settings, which brings me to a question about schemas. As far as I can tell Tessitura uses one schema called dbo. Since this is the case, I don't need individual schemas for each user, right? That's how our current system is set up.
Gloria,
I think you are almost correct. When I went hunting for objects under different schemas a few months ago, the only ones I found were two tables relating to NCOA export/import data that had been created under a schema with the user name of the person running the NCOA utility from the application.
Not sure if this was just an anomaly for us or if that was by design.
- Levi