Re: OT: allow access to database

2004-06-30 Thread Phill B
This will be on a dev server available to them. Basically I don't want them to have access to everything thing in the database. Just the tables they need. I guess I could export the just the tables they need rather than a complete backup of the database. On Wed, 30 Jun 2004 16:25:09 +0100, Thomas

Re: OT: allow access to database

2004-06-30 Thread Ray Champagne
That's what we do here - although, not being from a security background, I am not positive that this is the best way.  But others that I know of give read-only access this way, too. So, you would not be alone. Ray At 11:17 AM 6/30/2004, you wrote: >I have a developer that needs access to a data

Re: OT: allow access to database

2004-06-30 Thread Thomas Chiverton
On Wednesday 30 Jun 2004 16:17 pm, Phill B wrote: > I have a developer that needs access to a database. They suggested I > Here's my question. Wouldn't it be better to just create a user > account that has read only access to the tables that they will be > working with? Except then he'll be workin

OT: allow access to database

2004-06-30 Thread Phill B
I have a developer that needs access to a database. They suggested I give them a backup of it that they can work with. My first thought was OK but then I started thinking about it. I don't like the thought of some one having a complete copy of my database. Here's my question. Wouldn't it be better