Re: DBA_USERS: duplicated rows.

From: Kekko <dini.f_at_adr.it>
Date: Mon, 05 Jul 1999 08:19:17 +0200
Message-ID: <37804E65.34DFB8A0@adr.it>

These are the results of the query you told me:

SQLWKS> select USER#,NAME ,TYPE# from sys.user$ order by type#;

USER#      NAME                           TYPE#
---------- ------------------------------ ----------
         1 PUBLIC                                  0
         2 CONNECT                                 0
         3 RESOURCE                                0
         4 DBA                                     0
         7 EXECUTE_CATALOG_ROLE                    0
        19 DES2000_OWNER                           0
        20 CKR_SYSCASE                             0
        51 _NEXT_USER                              0
        48 IMP_FULL_DATABASE                       0
        47 EXP_FULL_DATABASE                       0
        49 RECOVERY_CATALOG_OWNER                  0
        44 SNMPAGENT                               0
        43 AQ_USER_ROLE                            0
        42 AQ_ADMINISTRATOR_ROLE                   0
         8 DELETE_CATALOG_ROLE                     0
         6 SELECT_CATALOG_ROLE                     0
         0 SYS                                     1
        50 SYSCASE                                 1
        45 DBSNMP                                  1
        28 CASE002                                 1
        29 CED1                                    1
        27 CASE001                                 1
        23 REPO                                    1
         5 SYSTEM                                  1
        21 CED                                     1

SQLWKS> select * from sys.user_astatus_map; STATUS# STATUS

---------- --------------------------------
         0 OPEN
         1 EXPIRED
         2 EXPIRED(GRACE)
         4 LOCKED(TIMED)
         8 LOCKED
         5 EXPIRED & LOCKED(TIMED)
         6 EXPIRED(GRACE) & LOCKED(TIMED)
         9 EXPIRED & LOCKED
        10 EXPIRED(GRACE) & LOCKED
         0 OPEN
         1 EXPIRED
         2 EXPIRED(GRACE)
         4 LOCKED(TIMED)
         8 LOCKED
         5 EXPIRED (TIMED)
         6 EXPIRED(GRACE) (TIMED)
         9 EXPIRED
        10 EXPIRED(GRACE)

18 rows selected.
SQLWKS> select * from sys.profname$;
PROFILE# NAME

---------- ------------------------------
         0 DEFAULT

1 row selected.
SQLWKS> select * from sys.profile$;
PROFILE# RESOURCE# TYPE# LIMIT# ---------- ---------- ---------- ----------

         0          0          0 2147483647
         0          1          0 2147483647
         0          2          0 2147483647
         0          3          0 2147483647
         0          4          0 2147483647
         0          5          0 2147483647
         0          6          0 2147483647
         0          7          0 2147483647
         0          8          0 2147483647
         0          9          0          0
         0          0          1 2147483647
         0          1          1 2147483647
         0          2          1 2147483647
         0          3          1 2147483647
         0          4          1 2147483647
         0          5          1 2147483647
         0          6          1 2147483647

17 rows selected.

Where is the problem? In the sys.profile$ perhaps? Thanks Kekko

Mark Malakanov wrote:

> check where is dulplication in tables:
>
> sys.user$, sys.user_astatus_map, sys.profname$, sys.profile$
>
> Regards,
> Mark
>
> Kekko <dini.f_at_adr.it> wrote in message news:377C6C5D.BA364B25_at_adr.it...
> > I still continue to have a problem with the dba_users view: it has
> > duplicated rows. I recreated it but the problem isn't resolved. Than I
> > modified the creaption script in the catalog.sql: I specified the select
> > distinct.
> > Oracle 8.0.5
> > Digital UNIX 4.0d
> > Digital Alpha Server 2100
> >
> > Thank you very much.
> >
> > Kekko
> >
> >
Received on Mon Jul 05 1999 - 01:19:17 CDT