actually I don't know how to get my rules yet, but let's assume the rules exist and we can get it from a function. get_forbidden_ids()
2011/7/17 Simon Slavin <slav...@bigfraud.org> > > On 17 Jul 2011, at 4:03am, san long wrote: > > > (process name) > > Implement this logic in your programming language, or do it by having your > app consult a table to see what has access to what database. > > SQL is a database language. You put data in and get the same data out > again. You don't get different data from the same database depending on > what you are. If you don't want all the records in a TABLE, use a 'WHERE' > clause on your SELECT command. > > > "A" (process name) can see all records except rowid 1,2 > > "B" .....except rowid 1,3 > > "C" ......except rowid 4,5 > > > You still haven't explained how your application is meant to know what has > access to which records. How does it know process C isn't meant to be able > to see record 4 ? Is this information stored with record 4, or in a table > about processes or what ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
