Re: [PERFORM] schemas to limit data access

2007-09-03 Thread Merlin Moncure
On 8/31/07, Brennan, Sean (IMS) <[EMAIL PROTECTED]> wrote: > Hi, > I was looking for opinions on performance for a design involving schemas. We > have a 3-tier system with a lot of hand-written SQL in our Java-based server, > but we want to start limiting the data that different users can access

[PERFORM] schemas to limit data access

2007-08-31 Thread Brennan, Sean \(IMS\)
Hi, I was looking for opinions on performance for a design involving schemas. We have a 3-tier system with a lot of hand-written SQL in our Java-based server, but we want to start limiting the data that different users can access based on certain user properties. Rather than update hundreds of

[PERFORM] schemas to limit data access

2007-08-31 Thread Brennan, Sean \(IMS\)
Hi, I was looking for opinions on performance for a design involving schemas. We have a 3-tier system with a lot of hand-written SQL in our Java-based server, but we want to start limiting the data that different users can access based on certain user properties. Rather than update hundreds of

[PERFORM] schemas to limit data access

2007-08-31 Thread Brennan, Sean \(IMS\)
Hi, I was looking for opinions on performance for a design involving schemas. We have a 3-tier system with a lot of hand-written SQL in our Java-based server, but we want to start limiting the data that different users can access based on certain user properties. Rather than update hundreds of