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] how to "enumerate" rows ?

2004-01-26 Thread Tom Lane
Karsten Hilbert <[EMAIL PROTECTED]> writes: >> Now, I need to enumerate the vaccinations per patient per >> disease. They are intrinsically ordered by their date of >> vaccination but I need to attach a number to them ... The best, recommended way to do this is to plaster on the row numbers in you

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

[SQL] how to "enumerate" rows ?

2004-01-26 Thread Karsten Hilbert
I sent this to pgsql-general first but eventually figured this list is the more appropriate venue for asking for help. If this happens to be a FAQ item please briefly point me where to go or what search terms to use in the archive. > First of all, yes I know that result rows don't have any > intr

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