bitwise or on column

Hi all,

I'm looking for a function doing a bitwise or on a column (number) containing permissions, e.g. 1=read, 2=write, 4=exec, ... (so 5 = exec+read permission).
There are several rows per user and all permissions should be aggregated. The function should be used like

select bitor(permissions)
from acl
where username='scott tiger';

TIA
Stephan Received on Tue Jul 16 2002 - 05:05:03 CDT