Hi, Oracle 9i (9.0.1), Win2000
c:\oracle\ora9i\rdbms\admin\catsnmp.sql: ... drop role SNMPAGENT; ... c:\oracle\ora9i\sysman\admin\catsnmp_734.sql, c:\oracle\ora9i\sysman\admin\catsnmp_80.sql, c:\oracle\ora9i\sysman\admin\catsnmp_8i.sql: ... drop role SNMPAGENT; create role SNMPAGENT; grant select on V_$LICENSE to SNMPAGENT; grant select on V_$VERSION to SNMPAGENT; ... Also c:\oracle\ora9i\rdbms\admin\catnsnmp.sql: ... drop role SNMPAGENT; ... Regards Lyubomir Petrov --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > you need to read that script a little more closely.. > in the 8.1.6 > rdbms/admin directory, in catsnmp.sql is the line > > create role SNMPAGENT; > > in fact, it's immediate after the drop role > statement. > > > --- Marin Dimitrov <[EMAIL PROTECTED]> wrote: > > > > hi, > > > > any ideas who is responsible for creating the > SNMPAGENT role? > > > > the catsnmp.sql script only drops it > > > > Oracle version is 9.0.1/ win2000 > > > > thanx, > > > > Marin > > > > ---- > > "...what you brought from your past, is of no use > in your present. > > When > > you must choose a new path, do not bring old > experiences with you. > > Those who strike out afresh, but who attempt to > retain a little of > > the > > old life, end up torn apart by their own memories. > " > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Marin Dimitrov > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California -- Public Internet > access / Mailing > > Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > > __________________________________________________ > Do You Yahoo!? > Great stuff seeking new owners in Yahoo! Auctions! > http://auctions.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyubomir Petrov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
