Re: user_db_links

Yes. It can be.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

Tony Vecchiet wrote:
>
> Do any of you know whether the user_db_links view can be recreated without the
> password field? Do any oracle standard packages use this view?
> I'm reluctant to change any standard oracle views, but our audit group is asking.
> thanks
>
> Version 8.0.5.1 database
>
> CREATE or replace VIEW USER_DB_LINKS as
> select l.name, l.userid, l.password, l.host, l.ctime
> from sys.link$ l
> where l.owner# = userenv('SCHEMAID')
Received on Wed May 03 2000 - 17:38:30 CDT