Re: Executing DBMS_RESOURCE_MANAGER_PRIVS in ATP
From: Leng <lkaing_at_gmail.com>
Date: Tue, 12 Nov 2019 17:31:28 +1100
Message-Id: <3C69693B-FA58-4006-97E9-3CFA89CC1866_at_gmail.com>
>> 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
Date: Tue, 12 Nov 2019 17:31:28 +1100
Message-Id: <3C69693B-FA58-4006-97E9-3CFA89CC1866_at_gmail.com>
Has your dba granted you execute privileges on this package?
> 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-lReceived on Tue Nov 12 2019 - 07:31:28 CET