>At 5/17/00 01:20 PM (Wednesday), Jason Wharton wrote:
>>So, following this model, I see the security stuff applying in parallel

just

>>the way that it applies to the other tables. Use the SELECT and INSERT
>>privilages to govern who can do what with messages.
>
>But...
>
>Since the message table holds all messages won't the SQL GRANT scheme fail
>to address security needs for different types of messages? GRANTS don't
>apply to subsets of rows, do they?

The same limitation applies to tables...

If you needed to partition your security for one message type or another you
do the same thing as you would with records of a table. Split the table into
two separate tables.

Under the model I was proposing you can have multiple message tables.

Jason Wharton
InterBase Developer Initiative
jwharton@...

InterBase will be the database of the new millennium.