Index/Unique Identifiers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Random - 30 Sep 2004 18:10 GMT

I'd like to get some feedback on preferred practices for indexes on
databases, and their use outside the database.

The situation I am trying to address is this. I have a set of XML documents
that I want to have hold collections of indexes that will be used to make
calls to a web service to gather current details on the topic the index
refers to in the database. I've always been fond of the use of unique
identifiers (GUIDs) for table indexes, and while the calls to the web
service will be secure, encrypted, & signed, I am hesitant to use the GUIDs
in this manner.

What security considerations do I need to be aware of in this design? What
recommendations would you offer?

Reply to this Message

Cowboy (Gregory A. Beamer) - MVP - 30 Sep 2004 20:29 GMT

I see no major problem. If you are concerned about someone compromising your
system, encrypt the actual strings and store the encrypt String and IV far
away from the data (XML).

There is also no reason you cannot store the XML where it cannot easily be
compromised, for further security.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

> I'd like to get some feedback on preferred practices for indexes on
> databases, and their use outside the database.
[quoted text clipped - 9 lines]
> What security considerations do I need to be aware of in this design? What
> recommendations would you offer?

Reply to this Message

Index/Unique Identifiers

Free Magazines