Re: Views?

From: Ralf Zwanziger <goldensurfer_at_gmx.de>
Date: Fri, 19 Jan 2001 08:45:47 GMT
Message-ID: <3a67fe5e.7534413@news.fth.sbs.de>

On Thu, 18 Jan 2001 15:23:08 GMT, Doug O'Leary <dkoleary_at_ro05-24-29-232-217.ce.mediaone.net> wrote:

>from dba_users
> *
>ERROR at line 3:
>ORA-00942: table or view does not exist

I think you must be sys or system to access dba_users:

select count(*) from dba_users

works when you are logged in as system, it doesn't work when you are logged in as a normal db user. Try the view "all_users" instead, this one works for normal users too.

Bye,
Ralf Received on Fri Jan 19 2001 - 02:45:47 CST