Re: Database link owned by a role instead of a user.

From: Shastry(DBA) <"Shastry>
Date: Sun, 3 Jul 2011 19:43:03 +0530
Message-ID: <CAFQkUXRsROOBFEbYVyq_pa4Rfm2esP4tnOKozmf+azwj-3V0wg_at_mail.gmail.com>

Database version: 11.2.0.1.0

SQL> select name from v$database;
NAME

---

PDPRD SQL> select username from dba_users where username ='MSM_STD_ADMIN'; no rows selected

SQL> select role from dba_roles where ROLE='MSM_STD_ADMIN'; ROLE

---

MSM_STD_ADMIN SQL> select owner,db_link from dba_db_links where owner='MSM_STD_ADMIN'; OWNER DB_LINK

------------------------------ ----------------------------------------

MSM_STD_ADMIN LINK.XXXXX.COM On Sun, Jul 3, 2011 at 7:25 PM, Shastry(DBA) <shastry17_at_gmail.com> wrote:

> Hi Gurus,
>
> There is one weird issue in my production database where database link is
> owned by a role instead of a schema owner. Any idea or suggestions on this
> please?
>
> Thanks,
> Shastry
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jul 03 2011 - 09:13:03 CDT