Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DBSNMP database user schema recreation

Re: DBSNMP database user schema recreation

From: Peter Schneider <pschneider_at_knuut.de>
Date: 17 May 1999 20:48:32 GMT
Message-ID: <374180ab.3109815@personalnews.de.uu.net>


"Eugene Firyago" <efiryago_at_bisys.com> wrote:

>Does anybody know how to recreate DBSNMP database user schema in case
>the DBSNMP database user has been dropped by
>mistake (with cascade option).

[...]

Hi Eugene,

you need to connect internal with server manager and then run the catsnmp.sql script from ORACLE_HOME/rdbms/admin, this will recreate the DBSNMP user along with the role/privs/synonyms.

HTH,
Peter

--
Peter Schneider
pschneider_at_knuut.de Received on Mon May 17 1999 - 15:48:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US