asked on

Row Level Access with SQL

Is there a way to do row level (essentially, column level) access with standard SQL without using vendor-specific packages?

tromm

You mean something like rowid in Oracle? (But then dbms independent, standard SQL)

tromm

Or do you mean rowlevel privileges?

ptjcb

I am confused by your question. Row level (essentially column level) access with standard SQL - do you mean ANSI-SQL? Do you mean some sort of SQL tool? Inquiring minds and all.

ASKER CERTIFIED SOLUTION

jrb1

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jrb1

Oops....i saw oracle in the first answer and was thinking this was an Oracle question. What DB are you talking about, or just SQL in general?

View are the simplest way to do this in any DB.

lcor

ASKER

jrb1 is right -- row level security.

I'm using Oracle and am finding that Oracle Label Security only goes to the table level.

jrb1

Not according to the Oracle 10g doc I posted above:

Oracle's 15th security evaluation is the first internationally recognized evaluation for Oracle Label Security, Oracle's server-enforced, row-level access control. Unique in the industry, Oracle Label Security allows many user communities to share the same database, yet only access data rows that pertain to each individual or community. It is the first and only independently evaluated security policy for controlling access to hosted-application data in a consolidated data repository.

SOLUTION