DBA_TABLESPACES ACCESS PRIVILEGES

book

Article ID: 48988

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction

Description:

After observing the permissions in database for user "aedbadmin",

we have noticed that there is a SELECT privilege on DBA_TABLESPACES assigned to the UJOADMIN role.

Please confirm is it necessary for application to have such permissions.

and any other alternatives if possible. Can you confirm why "SELECT privileges on dba_tables and dba_tablespacs" are required?

Solution:

The UJOADMIN role besides having a SELECT, DELETE, INSERT, UPDATE and EXECUTE on AutoSys tables and stored procedures

would also require the SELECT privileges on dba_tables and dba_tablespaces.

It would also require ANALYZE ANY for the dbstatistics and dbspace to work properly.

The "SELECT privileges on the dba_tables and dba_tablespacs" are required for database maintenance tasks specially the "dbspace" utility.

Environment

Release: ATSAGE99000-11.3-Workload Automation AE-Remote Agent
Component: