Re: creating users

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_at_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.
Received on Tue Jun 06 2000 - 00:00:00 CDT