Re: Executing DBMS_RESOURCE_MANAGER_PRIVS in ATP

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_at_gmail.com> wrote:

> Has your dba granted you execute privileges on this package?
>
> Cheers,
> Leng
>
> On 12 Nov 2019, at 3:39 pm, Arpit Aggarwal <arpitdba2019_at_gmail.com> 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_at_gmail.com> 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_at_gmail.com>
>> wrote:
>> >
>> > 'SYS.DBMS_RESOURCE_MANAGER_PRIVS' must be declared
>>
>

--
http://www.freelists.org/webpage/oracle-l