Re: grant access to new user

and dont forget, that the grants must be made by the owner of the table. and if you are not using synonyms, you must type in the owner of the object that you want to select from, if
you want to access these objects as another user.

e.g.

select * from user1.table1;

select * from <owner_name>.<object_name>

kurti_at_kurti.cc wrote:

> you have to give him acces to any object that he may have access to.
>
> e.g.
>
> grant select on table1 to username;
> grant insert on table2 to username;
>
> or
>
> grant select any table to username;
>
> depends on what you want to grant him/her.
> kurt
>
> Thomas Vatter wrote:
>
> > I have created a database as 'system' and try to give access for other
> > users. I created a new user with 'create user identified by passwd' and
> > made 'grant connect to user' and 'grant select, insert, update to table'.
> > But after that the new user can't select the tables, error is 942, Table
> > or view not found. Same in sqlplus as with jdbc.
  Received on Tue May 08 2001 - 09:04:45 CDT