Re: Giving grants

Satish,

Grant object level privileges (select,update...) on objects (tables,views) to user (in ur case X).

Syntax is:

grant select[,update,delete...] on <schema.table> to <user> ;

u have to connect either as owner or as system (any dba priv. user).

The other way is to create role and grant the role to users.

Good luck,

Jakh

satish plakote wrote:

> hi,
> i have a set of tables in a database which is created and owned by me,now i
> want to grant only limited privileges to user 'X' on those tables, so that
> he can carry on with his daily work.
> I am not sure of the syntax of the sql stmt to be issued.
> Can somebody help!
> Thanks
> satish
>
> _______________________________________________________
> Say Bye to Slow Internet!
> http://www.home.com/xinbox/signup.html
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: satish plakote
> INET: satish_plakote_at_excite.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Sun Oct 15 2000 - 23:34:18 CDT