Re: Snapshot Rep. between 2 schemas in same instance

Sprog wrote:
>
> Why not have a column in each table called readable_flag that defaults to 0.
> The admin users can enter their data and when they are ready to let the
> other users see their data, they can update each table and set readable_flag
> to 1.
>
> Then create views based on these tables that do a select * from tablename
> where readable_flag = 1. Give the ordinary users select privileges on these
> views. This means that you don't need a second schema or a second database.
>
> Regards
<snip>
And what when the admin's are updateing? When they set the flag back to 0,
there's no data for the users (view selects where flag=1, right?). Won't work in the way the original poster meant it.

-- 
Gtrz,

Frank van Bortel