Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create User
Johan den Boer wrote:
> Hi,
>
> I create a database with user id 'database'. Now I want to give other
> users
> permission to access my table. I created a new user with
>
> sqlplus and logon with system and manger. Than I do
>
> create user 'ops$newid' identified by 'password'
> default tablespace table
> temporary tablespace temp;
>
> I give grant permissions like grant select all table to ops$newid or
> grant dba to ops$newid.
>
> When the new user executes sqlplus / and want to do some selects on
> tables
> he gets the message object does not exist.
> What's wrong ? Have I something forgotten ?
>
> regards Johan den Boer
>
> email : jj.den.boer_at_hccnet.nl
You will need to create synonyms, or have the select statement preface the table name with the owner (like ops$uid.table_name).
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Sat Jun 12 1999 - 07:29:56 CDT