Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: USER

Re: USER

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sun, 27 May 2001 22:04:51 GMT
Message-ID: <7SeQ6.66824$p33.1409547@news1.sttls1.wa.home.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US