Re: View DBA_USERS Oracle 8.0.5

From: <markp7832_at_my-deja.com>
Date: Tue, 15 Jun 1999 20:40:29 GMT
Message-ID: <7k6dnq$17a$1@nnrp1.deja.com>

In article <37668867.BB8BCEA8_at_adr.it>,
  Kekko <dini.f_at_adr.it> wrote:
> I have a problem with this view: it has duplicated rows!
> I have rebuilded the view (from catalog.sql) but the problem is not
> changed.
> Can something help me?
> Thanks
> Kekko
>

The view DBA_USERS appears fine on our platform, Sequent, ver. 8.0.5. Are you sure it is not some type of terminal display problem? Here is the sql from catalog.sql for comparision. Good Luck.

create or replace view DBA_USERS

    (USERNAME, USER_ID, PASSWORD, ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE,

        DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE, CREATED, PROFILE,
        EXTERNAL_NAME)

as
select u.name, u.user#, u.password,

       m.status,
       decode(u.astatus, 4, u.ltime,
                         5, u.ltime,
                         6, u.ltime,
                         8, u.ltime,
                         9, u.ltime,
                         10, u.ltime, NULL),
       decode(u.astatus,
              1, u.exptime,
              2, u.exptime,
              5, u.exptime,
              6, u.exptime,
              9, u.exptime,
              10, u.exptime,
              decode(u.ptime, '', NULL,
                decode(pr.limit#, 2147483647, NULL,
                 decode(pr.limit#, 0,
              decode(dp.limit#, 2147483647, NULL, u.ptime +
                     dp.limit#/86400),
                   u.ptime + pr.limit#/86400)))),
       dts.name, tts.name, u.ctime, p.name, u.ext_username
       from sys.user$ u, sys.ts$ dts, sys.ts$ tts, sys.profname$ p,
            sys.user_astatus_map m, sys.profile$ pr, sys.profile$ dp
       where u.datats# = dts.ts#
       and u.resource$ = p.profile#
       and u.tempts# = tts.ts#
       and u.astatus = m.status#
       and u.type# = 1
       and u.resource$ = pr.profile#
       and dp.profile# = 0
       and dp.type#=1
       and dp.resource#=1
       and pr.type# = 1
       and pr.resource# = 1

/

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 15 1999 - 15:40:29 CDT