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
>
> On 17 Jul 2011, at 4:03am, san long wrote:
>
> > (process name)
>
> Implement this logic in your pr
It seems that my words are still ambiguous, let me make it further clear.
there are many processes in the system (ie, linux ), they use the sqlite
databases, I add many rules to allow/forbidden their access to the
databases, such as:
"A" (process name) can see all records except rowid 1,2
"B"
ocess. You could then create the
> temporary view as a join between the real table and the temp table. You
> also need to create the associated triggers for the user in that process
> to use.
>
> But in the end, I am just guessing what you are really trying to do, so
> I may be o
sqlite3 support a trigger on SELECT ? View is a good solution, but I
want to let different process see different records, like:
pid A sees rowid 1,2
pid B sees rowid 1,3
2011/7/16, san long :
> haha, if I CREATE VIEW in process A and DROP VIEW when A dies. Process
> B could see this VIEW
haha, if I CREATE VIEW in process A and DROP VIEW when A dies. Process
B could see this VIEW or not?
A and B run at the same thime.
2011/7/16, Simon Slavin :
>
> On 16 Jul 2011, at 4:23am, san long wrote:
>
>> Thanks for advice, delete or update the record in a view could affect th
right, but now I just want to hide these records to all processes.
2011/7/16 Igor Tandetnik
> On 7/15/2011 9:19 PM, san long wrote:
> > Dear all,
> > I have an idea related to the safety of the records in a table: if it is
> > possible to hide some records in a ta
Thanks for advice, delete or update the record in a view could affect the
true table in sqlite now?
And, if I create a view dynamically using sqlite3_exec, is it visible to
other process who opens the same database?
2011/7/16 Simon Slavin
>
> On 16 Jul 2011, at 2:19am, san long wrote:
&
Thanks for replies.
It doesn't matter no application can see the underlying data as long as they
exist physically. I just want to hide them.
2011/7/16 Simon Slavin
>
> On 16 Jul 2011, at 2:32am, Danny wrote:
>
> > In my mainframe days, using IDMS/SQL, I limited user access to table
> data, down
Dear all,
I have an idea related to the safety of the records in a table: if it is
possible to hide some records in a table so the upper user application could
not see them?
For example:
table food has content:
1, "food A"
2, "food B"
I want to hide the record whose rowid is 2, so:
sqlite> SELECT
9 matches
Mail list logo
