Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Creating new user/privilege for stats collection

User_JSTMS
Member Posts: 1 Blue Ribbon
As enterprises are more concerned on the security aspect , we have got concern from Our security team to reduce the SYS user usage in the DB. When we had a check Oracle automated maintenance tasks such as stats collection , segment advisor and tuning advisor jobs are getting created under SYS due to which we see lot of audit events recorded against SYS user in Unified audit trail table. So to reduce this can we look at moving this our of SYS by introducing separate privilege/user as like SYSRAC, SYSDG for these maintenance tasks with restricted permissions related to stats collection alone.
Tagged: