RE: cfdynamics.com (Sql server setup question)

[Ian Skinner]

Well, not quite the same.  If you use the schemas, then you can easily create database users that only have access to a certain schema.  You can then easily set up different DSN's that uses a particular user name so that it is tied to a certain schema and thus can only access those particular tables.  


According to the documentation, it only costs $5 to set up new DSN's after the first two, so that shouldn't run up too big a bill, if it is worth it to you to segregate the data from different clients.
--------------
Ian Skinner
Web Programmer
BloodSource
<file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org> www.BloodSource.org <http://www.BloodSource.orgSacramento>
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---