|Subject||Re: [IB-Architect] Messaging API|
>At 5/17/00 01:20 PM (Wednesday), Jason Wharton wrote:just
>>So, following this model, I see the security stuff applying in parallel
>>the way that it applies to the other tables. Use the SELECT and INSERTThe same limitation applies to tables...
>>privilages to govern who can do what with messages.
>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?
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.
InterBase Developer Initiative
InterBase will be the database of the new millennium.