Re: User account

Did you create a user 'guest'? The easiest way is to make the user 'guest' owner of the insert-table.
If you want to be sys the owner of the insert-table you have to create a synonym for the sys.insert-table.
But sys is a dangerous owner with a very lot of privileges. To me the best way seems to create a other user and to make him owner of the insert-table.

Hans

Raimund Alker wrote:

> I have got a problem.
>
> I´m developing a Java Applet to access Oracle from the WWW.
> The internet user should have just SELECT privilege on one table and
> just INSERT on another one.
> I´ve granted this privileges as "sys" but the user ("guest") does not
> find the tables.
> The tablespace is the same, but the problem seems to be that the owner
> of the tables is "sys".
> If i enable "guest" to create his own tables, he´ll have access on ALL
> this tables.
>
> Can anyone help me?
>
> Ray

--

  Hans Brinkman


 to reply: change 'company_name.nl' to 'capgemini.nl'