unable to log in

Posted on 2011-10-12
Last Modified: 2012-05-12
i created a user and grated user with password protected role which already exist.

can we grant a password protected role with out password.---->question 1

the user is not able to log in.
but when this password protected role is revoked they are able to log in.

I dont know what to do. please help me.

Thank you
Question by:ajaybelde
    LVL 73

    Expert Comment

    >> can we grant a password protected role with out password

    no,  if it needs to be password protected, then it needs to have a password
    LVL 73

    Expert Comment

    if the role is enabled by  default that is likely the problem.

    rather than revoking the role,  disable it as a default.

    alter user YOURUSER default role all except YOURROLE

    Author Comment

    "if the role is enabled by  default that is likely the problem."

    Can you please explain  more in detail.

    Author Comment

    how to grant that password protected role to user. Syntax please

    It is just grant ROLENAME to USERNAME or some thing else.

    LVL 73

    Accepted Solution

    roles are assigned (granted) to users, but aren't necessarily active.

    select * from dba_role_privs

    if DEFAULT_ROLE = YES, then that role is enabled when the user logs in.   Password protected roles should be NO.

    In order to enable a password protected role  the user must issue the SET ROLE command

    to grant a role (protected or not) is  as you stated.

          grant ROLENAME to USERNAME

    to enable a disabled role

          set role ROLENAME

    to enable a protected role

          set role ROLENAME identified by ROLEPASSWORD

    LVL 73

    Assisted Solution

    I recommend reading up on roles, defaulting, password protection, etc  in the Security Guide

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now