Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: grant access to new user
thanks kurt, i cant believe it, it is just giving the owner-name in front of the table-name, for instance user1.table1, exactly as you said. my hours width the manual didnt help finding this.
On 08 Mai 2001, you wrote in comp.databases.oracle.server:
>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 - 11:50:02 CDT