Re: ora-1031 granting create session

From: Powell, Mark <mark.powell2_at_dxc.com>
Date: Tue, 19 Feb 2019 20:46:59 +0000
Message-ID: <DM6PR01MB391465515B4BD0AA141CD9B8CE7C0_at_DM6PR01MB3914.prod.exchangelabs.com>



Jeffery, who owns this in-house developed stored procedure? Did they need a direct grant on a SYS owned object to perform the task? If so, SYS issued direct grants can be lost during upgrades and migrations requiring the object privileges be re-issued. Maybe this is your issue. If you had posted the Oracle error returned on the GRANT it would have been helpful. A portion of the code might also be needed if this is not the issue.

Mark Powell
Database Administration
(313) 592-5148



From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> Sent: Tuesday, February 19, 2019 3:26 PM To: oracle-l-freelist
Subject: ora-1031 granting create session

I have a procedure that a system admin uses to create an oracle account and grant create session privilege and a role. This was working fine in 11G. We have now upgraded to 12c. The grant of the create session privilege is failing. What new 12C privilege do I need to do the grant?

DXC Technology Company - Headquarters: 1775 Tysons Boulevard, Tysons, Virginia 22102, USA. DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. --.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 19 2019 - 21:46:59 CET

Original text of this message