Re: grant access to new user

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:00:17 CDT