Re: What privs do other users need for my tables???

Normal priviliges are
select, insert, update, delete
Prior to Oracle 8.0 update privilege implied select privilege. This has been changed to conform with standards.
Alter privilege doesn't belong to the normal set. It gives all your users the privilege to alter the structure of your table. IMHO grant select any sequence should also be used with caution. Of course all the users would also need either a private or a public synonym to your table, in order to avoid hardcoded tableowners.

Hth,

Sybrand Bakker, Oracle DBA

"Richard Hollingsworth" <william.hollingsworth_at_hsv.boeing.com> wrote in message news:39513088.25EFDD5A_at_hsv.boeing.com...
> Hi:
>
> I have a table that I created, and then build a forms 5.0 form to access
> that table. I can run the form ok, but other users get an error when
> they try to update the table using the form. PS. The form also has a
> couple of triggers.
>
> What privs/roles do other users need to update my table?
>
> I tried the usual "Alter", "Update", "Insert", and the ever present
> "Grant select any sequence".
>
> But the users still cannot update my table.
>
> What's up?
>
> Thanks,
> Richard Hollingsworth
Received on Thu Jun 22 2000 - 00:00:00 CDT