Re: Q. Granting Priveleges in Oracle

Dear Sir:

I can't check it ( I am not working currently in distr. env., but probably, you can avoid this problem by creating a remote view:

create view table_view is select col1,col2,... from table__at_link_;

and ROWTYPE% view instead of table.

Seems to me, Oracle can't find datatypes of column specifications in your data dictionary, where they don't exist (for sure).

If I wrong, please, forgive me.

I would appreciate if you send me the result.

Best wishes,
Eugene.

jagan wrote:
>
> Hello,
>
> I'd like to know if there is any way to grant priveleges in Oracle to
> alter a row in a table only if that row has been inserted by that user.
>
> For example: If an agent "A" handles customer "C", Customer "C" record
> should only be altered by agent "A"
>
> A way I can think of is inserting an attribute in the customer table
> showing who the agent is and let the application take care of this
> access.
>
> Any ideas if there is a better way or if there is a GRANT privelege in
> Oracle that can accomplish this task.
>
> Thanks, in advance.
>
> Jagan Kodali
> (408)985-2750
Received on Thu Jul 11 1996 - 00:00:00 CEST