Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

User grant for restrected session is not working

Siddharth SinghJan 30 2019 — edited Jan 31 2019

I am trying to allow a user to access database during the restricted session. I followed below steps.

grant restricted session to <user>;

alter system enable restricted session;

But user still not able to login and got error ora-12514 (which is related to listener)

Once I will disable the restricted session same user will be able to login.

Comments
Post Details
Added on Jan 30 2019
13 comments
3,813 views