record level permissions

From: <rosek_at_my-dejanews.com>
Date: Wed, 02 Dec 1998 14:53:35 GMT
Message-ID: <743k9d$n02$1@nnrp1.dejanews.com>

Here is my problem.

I have several flatfiles that I want to load into the same database table. However each flatfile is owned by a different user. I would like to allow users to only be able to access their own data within the table.

I know I could replicate the data for each user or I could include an attribute to denote ownership.

However, I was wondering if Oracle 8 Enterprise Server supported some form of record level permissions - where I could permit a user to access a record or group of records within a table.

Im looking for the following? 1. Is this possible - is there a built in method for this. 2. What Oracle documentation would describe this feature. 3. Any examples or insight into this problem. 4. What tool I can use to manipulate these permissions ? ie Enterprise Manager? - can I assign the permissions on load with SQL Loader ? Thanks Kevin Rose

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 02 1998 - 08:53:35 CST