Re: Newbie's question: create user but can't access db object

Lito Kusnadi wrote:
>
> Hi, somebody please help me.
>
> I installed oracle 8i 815 on Win2k.
> I create a user that has admin privileges: practice09.
> Then I create tables using practice09.
>
> I create user: dummyone, through practice09, and grant dummyone select,
> insert, update, and delete to the tables I created using practice09.
>
> When I logged as dummyone, and type: desc item_tbl; it says "Error: database
> object doesn't exist".
>
> I tried to check if the tablespace I used for practice09 is offline. Not,
> it's online.
> I'm run out of ideas. Why my account can't be used?
>
> And also, why when I write a script in .sql file and add savepoint to the
> very beginning of each file, I can not use rollback to [savepoint_name]
> during my session on sql-plus? I do this in order to be able to undo the
> script I executed.
>
> Thanks for your help.

This user cannot see the table because there is no synonym (public) created for the table by practice09.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.