Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBSNMP database user schema recreation
"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