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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to