I am myself a dba and on creating this ATP database from OCI, we get only
admin user created which is not a super user and hence it cannot have dba
priveleges.
Thanks,
Arpit
On Tue 12 Nov, 2019, 12:01 PM Leng, <lkaing@xxxxxxxxx> wrote:
Has your dba granted you execute privileges on this package?
Cheers,
Leng
On 12 Nov 2019, at 3:39 pm, Arpit Aggarwal <arpitdba2019@xxxxxxxxx> wrote:
Yes Leng , understood that point but in ATP we get only ADMIN user logins
and it doesn't have sys privileges.
Is there an alternative way this can be done ?
On Tue, 12 Nov 2019 at 01:58, Leng <lkaing@xxxxxxxxx> wrote:
The below error means the object doesn’t exist or you’re lacking
privileges to see/use it
'SYS.DBMS_RESOURCE_MANAGER_PRIVS' must be declared
Cheers,
Leng
On 11 Nov 2019, at 5:22 pm, Arpit Aggarwal <arpitdba2019@xxxxxxxxx>wrote:
'SYS.DBMS_RESOURCE_MANAGER_PRIVS' must be declared