From: Jerry Gitomer <jgitomer@erols.com>
Subject: Re: creating users
Date: 2000/06/06
Message-ID: <20000606.5262300@p200.nodomain>#1/1
Content-Transfer-Encoding: quoted-printable
References: <8hh1r6$j2h$1@nnrp1.deja.com>
X-Priority: 3 (Normal)
Content-Type: text/plain; charsetISO-8859-1
X-Complaints-To: abuse@rcn.com
X-Trace: 2N2qkhZLY8vO1QWd/lkUg6iZPAZ+iq1qc1Z37tKqPOE
Mime-Version: 1.0
NNTP-Posting-Date: 6 Jun 2000 04:24:12 GMT
Newsgroups: comp.databases.oracle.server





	1. Have the owner of each view or table grant access to your new 
account and then modify your queries prefix each table and view name 
with <schema name>. Where <schema name> is the name of the owner of the 

gable or view  e.g.  Sys.v$sqlarea

	2. As the owner of the tables or view create a public synonym. (you 
may still have to grant explicit access  )

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 6/5/00, 3:16:57 PM, bilal z@my-deja.com wrote regarding creating 
users:


> I am trying to create a new user with full priviliges to replace the
> default SYSTEM/MANAGER user on 8i.
> I managed to create it and assign it the DBA role. However, it does 
 not
> seem to have access to the database I've created i.e. upon a 'select'
> or even a 'desc' it claims that table or view does not exist. When I
> log into the same database with 'system/manager', it displays the
> tables fine.
> Can anyone please tell me how to remedy this?
> Thanks much.


> Sent via Deja.com http://www.deja.com/
> Before you buy.