OraFAQ Forum: Enterprise Manager » Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen

Home » RDBMS Server » Enterprise Manager » Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen (10.2.0.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen [message #632333]

Thu, 29 January 2015 02:49

smac
Messages: 16
Registered: August 2013

Junior Member

Whenever I add a privilege or role to a user in this 10g database and look at sql generated it's first line is 'alter user xxxx identified by 'xxxxxxxxx''
the password is always xxxxxx and causes the user to have to reset there password.
Profile of user if default and nothing changed.
Any idea why it does this or is it a bug as I know it does not do this at 11g.
thanks

Report message to a moderator

Re: Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen [message #632335 is a reply to message #632333]

Thu, 29 January 2015 03:39

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't understand anything of what you say.
Use SQL*Plus and copy and paste what you do and get.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Also, feedback and thank people who helped you in your previous topics.

Report message to a moderator

Re: Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen [message #632338 is a reply to message #632335]

Thu, 29 January 2015 03:46

smac
Messages: 16
Registered: August 2013

Junior Member

Michel,
In oracle enterprise manager I add a role TEST_ROLE and when I view sql created this is whats shown

ALTER USER "FRED" IDENTIFIED BY "*********"
GRANT "TEST_ROLE" TO "FRED"
ALTER USER "FRED" DEFAULT ROLE ALL

Why is it changing the password or corrupting password as u have to reset password to be able to login as FRED from this point.

thanks

Report message to a moderator

Re: Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen [message #632340 is a reply to message #632338]

Thu, 29 January 2015 03:49

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So this is an EM question not a Server Administration one.
I think you misuse the tool.
You have to post the screens you filled to do this action.

Report message to a moderator

Re: Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen [message #632341 is a reply to message #632338]

Thu, 29 January 2015 03:49

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

As Michel said, Copy & Paste a SQL*Plus session which demonstrates the behaviour you describe.

Report message to a moderator

Re: Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen [message #632343 is a reply to message #632341]

Thu, 29 January 2015 03:53

smac
Messages: 16
Registered: August 2013

Junior Member

I don't think I have misused any tools just a genuine mistake, if you cant help I will repost under correct area.
the OEM creates the sql statements itself NOT a SQL*Plus session. OEM you just point and clicking adding role to a user and showing sql created by OEM before applying.

Report message to a moderator

Re: Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen [message #632344 is a reply to message #632343]

Thu, 29 January 2015 03:55

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I moved it to the correct forum.
As I said you have to post the screen you filled to execute this action.

Report message to a moderator

Re: Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen [message #632361 is a reply to message #632344]

Thu, 29 January 2015 07:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Given that V10 is no longer supported, the real question is does this behavior still exist in V12 release.
Even if a bug in V10, it will never be corrected in V10 release; so why is this an issue now?

Report message to a moderator

Previous Topic:	Issue while install and configure EM.
Next Topic:	Oracle 12C Cloud control instalation issue (unable to deployee agent software)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 06 08:00:49 CST 2025