(Hemant K Chitale) Here is a quick demo to show that the “ADMINISTER SQL MANAGEMENT OBJECT” privilege is required for a non-DBA user to use DBMS_SPM even if EXECUTE has been granted on DBMS_SPM.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help