Re: [SQL] Label Security

2004-01-26 Thread Bruno Wolff III
On Mon, Jan 26, 2004 at 16:50:06 -0800, James Taylor <[EMAIL PROTECTED]> wrote: > Ok, so for example, say I add another column to the tables I want to > have the row-level security on called 'security'. I would go ahead and > designate > different security levels for each user, (ex. Jane secur

Re: [SQL] Label Security

2004-01-26 Thread James Taylor
Ok, so for example, say I add another column to the tables I want to have the row-level security on called 'security'. I would go ahead and designate different security levels for each user, (ex. Jane security 1000, Bill 2000, Joe 3000). Then, if I only want X user with security 1000 to view

Re: [SQL] Label Security

2004-01-26 Thread Bruno Wolff III
On Mon, Jan 26, 2004 at 12:45:40 -0800, James Taylor <[EMAIL PROTECTED]> wrote: > I'm migrating an Oracle 9 database over to Postgres 7.3.4, and just ran > into something I've never seen before (honestly, due to my lack of > experience in Oracle) and was curious if > Postgres supported anything

[SQL] Label Security

2004-01-26 Thread James Taylor
I'm migrating an Oracle 9 database over to Postgres 7.3.4, and just ran into something I've never seen before (honestly, due to my lack of experience in Oracle) and was curious if Postgres supported anything similar. The DBA that set up Oracle appears to have enabled Oracle Label Security, whi