[Last Call] Learn how to a build a cloud-first strategyRegister Now


unable to log in

Posted on 2011-10-12
Medium Priority
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
  • 4
  • 2
LVL 74

Expert Comment

ID: 36958319
>> 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 74

Expert Comment

ID: 36958331
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

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

Can you please explain  more in detail.
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.


Author Comment

ID: 36958443
how to grant that password protected role to user. Syntax please

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

LVL 74

Accepted Solution

sdstuber earned 2000 total points
ID: 36958506
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 74

Assisted Solution

sdstuber earned 2000 total points
ID: 36958530
I recommend reading up on roles, defaulting, password protection, etc  in the Security Guide


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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 videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses
Course of the Month18 days, 9 hours left to enroll

825 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