[Opensource] designs for row-level privilege checking?

[BSC]

<snip>
>
>>For a first cut, I suppose I could punt on the long varchar, and just keep 
>>it a varchar 255.  Any target table with a primary key which does not fit 
>>in this limit just doesn't work for now.  In practice, I expect that the 
>>vast majority of primary keys would fit in a varchar 255.
>
>I agree with you.  Although now that I think of it, InterBase may have a 
>problem with a varchar(255) key... I think the biggest I could ever do when 
>I was playing with it was varchar(160). [Can a current Firebird/InterBase 
>user confirm?]

A single-column varchar index in Firebird/Interbase is limited to 252 characters - the other 4 characters are buitin overhead.  Multi-column indices incur additional overhead and would therefore reduce the maximum number of total bytes allowed to a number less than 252.


Aime


__________________________________________________________
Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access,
No Ads and No Taglines with LYCOS MAIL PLUS.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus