Deleting DB User

book

Article ID: 207344

calendar_today

Updated On:

Products

CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

I have one more question, we have DB user (wilymgr5) which not in use now, can we cleanup/remove that particular user/ID data from DB server ? if yes, what is the procedure ?

 

Environment

Release : 10.7.0

Component : APM Agents

Resolution

APM DB has a users table  in ts_user. APM itself stores users in users.xml, EEM, or LDAP. The user can be removed from these data stores.

Oracle has a DROP User command. https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9008.htm