[sqlite] Defining user groups in SQLite table

another way of doing this? So, group 1 has access to code1, code2, code3, code4, code5; group 2 has access to code1, code2, code3; group 3 has access to code 2, code3, code4. etc. Thanks in advance for any suggestions! -- View this message in context: http://www.nabble.com/Defining-user-groups

Re: [sqlite] Defining user groups in SQLite table

On Thu, Sep 03, 2009 at 10:57:13AM -0700, karenebs scratched on the wall: I have a database table that holds about 20,000 codes. Each code can be used by several different user groups. I could add a column to the database table for each user group to indicate which codes that particular

Re: [sqlite] Defining user groups in SQLite table

table groups ( group_id, group_descri ) table access ( rela_group, rela_code) --- El jue 3-sep-09, karenebs ka...@echobasesoftware.com escribió: De: karenebs ka...@echobasesoftware.com Asunto: [sqlite] Defining user groups in SQLite table Para: sqlite-users@sqlite.org Fecha: jueves, 3 de

Re: [sqlite] Defining user groups in SQLite table

On Thu, Sep 03, 2009 at 10:57:13AM -0700, karenebs wrote: I have a database table that holds about 20,000 codes. Each code can be used by several different user groups. I could add a column to the database table for each user group to indicate which codes that particular group has access to.

Re: [sqlite] Defining user groups in SQLite table

On 3 Sep 2009, at 6:57pm, karenebs wrote: I have a database table that holds about 20,000 codes. Each code can be used by several different user groups. I could add a column to the database table for each user group to indicate which codes that particular group has access to.