BLOBS and security

Started by Philip Warnerover 26 years ago2 messages
#1Philip Warner
pjw@rhyme.com.au

Another thing that whoever is implementing BLOBS will have to be aware of
is making sure that access to individual BLOBS is controlled by the
'owning' table.

I don't know if an implementation has been settled on, but at one point it
was suggested that BLOBs be stored in a single table. I suspect this
approach would not work for the above reason.

Also, is there any reason why BLOBs need to be stored in a table at all?
Can lower level I/O routines to be used to chain groups of pages together?

Finally, is there a plan for the BLOB implementation that is available for
comment?

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: +61-03-5367 7422 | _________ \
Fax: +61-03-5367 7430 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

#2A James Lewis
james@fsck.co.uk
In reply to: Philip Warner (#1)
Re: [HACKERS] BLOBS and security

Is there likley to be a way to use BLOBS via psql????

On Tue, 27 Jul 1999, Philip Warner wrote:

Another thing that whoever is implementing BLOBS will have to be aware of
is making sure that access to individual BLOBS is controlled by the
'owning' table.

I don't know if an implementation has been settled on, but at one point it
was suggested that BLOBs be stored in a single table. I suspect this
approach would not work for the above reason.

Also, is there any reason why BLOBs need to be stored in a table at all?
Can lower level I/O routines to be used to chain groups of pages together?

Finally, is there a plan for the BLOB implementation that is available for
comment?

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: +61-03-5367 7422 | _________ \
Fax: +61-03-5367 7430 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

A.J. (james@fsck.co.uk)
Sometimes you're ahead, somtimes you're behind.
The race is long, and in the end it's only with yourself.