Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: USER
The creator of the table can log in and say grant select, insert,update,delete on Y to X; or if you just want them to be able to read it: grant select on table y to x;
Jim
"EJ" <emmjj_at_pandora.be> wrote in message
news:p9cQ6.12378$X03.1091950_at_afrodite.telenet-ops.be...
> Learning sql
> Have some problems in sql
>
> I do not understand how I can create a different user and grant access to
> some tables
>
> example
>
> create user X
> identified by X1
>
> what is(are) the next step(s) to table access
>
> example table Y
>
>
> Thanks
>
>
Received on Sun May 27 2001 - 17:04:51 CDT