Re: grant access

 log on as system...or someone allowed to make users...

create user user_name identified by password; grant resource,connect to user_name;

log on as owner of table i.e. scott/tiger ect... grant update,select,delete on schema_name.table_name to user_name;

    or just table_name....
     (eg scott.blob or blob where blob is a table.....)

Make sense??

Ed Lufker wrote:

> Hi All:
>
> I need to create a user and allow it access to just one table, how would I
> do this??? What would the commands be?
>
> thanks in advance
> eddie lufker
Received on Mon Feb 16 1998 - 00:00:00 CST