OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » The aim of WMSYS (Oracle 9i)

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

The aim of WMSYS [message #452211]

Tue, 20 April 2010 11:48

Amine
Messages: 376
Registered: March 2010

Senior Member

Hi All,
A question about the WMSYS user that comes with the default installation :

I've locked it because it has the DBA role. The question is :
Will this impact the database ? Will something go wrong ?

Thank you in advance,

Amine

Report message to a moderator

Re: The aim of WMSYS [message #452212 is a reply to message #452211]

Tue, 20 April 2010 11:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I've locked it because it has the DBA role. The question is :
>Will this impact the database ? Will something go wrong ?

Ready, Fire, AIM!

When all else fails, Read The Fine Manual

http://download.oracle.com/docs/cd/B10501_01/win.920/a95490/username.htm#1005767

Report message to a moderator

Re: The aim of WMSYS [message #452213 is a reply to message #452212]

Tue, 20 April 2010 11:57

Amine
Messages: 376
Registered: March 2010

Senior Member

I know that Mr BlackSwan,
But nothing is said about the repercussions by locking this user, even if we don't need the Workspace Manager

Report message to a moderator

Re: The aim of WMSYS [message #452221 is a reply to message #452213]

Tue, 20 April 2010 13:33

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

Senior Member
Account Moderator

And you rely on an answer from a forum?
OK, we lock this account, what will you do with that?

Regards
Michel

Report message to a moderator

Re: The aim of WMSYS [message #452298 is a reply to message #452211]

Wed, 21 April 2010 04:15

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Hi,

Are you using oracle workspace manager?
WMSYS used to store all the metadata information for Oracle Workspace Manager.

WMSYS is created if Oracle Workspace Manager script owmctab.plb is executed.

Thanks-
P

[Updated on: Wed, 21 April 2010 04:16]

Report message to a moderator

Re: The aim of WMSYS [message #452304 is a reply to message #452298]

Wed, 21 April 2010 04:34

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

Senior Member
Account Moderator

No, we are not but we have the schema.

Regards
Michel

[Updated on: Wed, 21 April 2010 04:36]

Report message to a moderator

Re: The aim of WMSYS [message #452306 is a reply to message #452211]

Wed, 21 April 2010 04:38

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Then there will not be a problem if we lock the user WMSYS.

Thanks-
P

Report message to a moderator

Re: The aim of WMSYS [message #452309 is a reply to message #452306]

Wed, 21 April 2010 04:45

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

Senior Member
Account Moderator

We had none... till now.

Regards
Michel

[Updated on: Wed, 21 April 2010 04:46]

Report message to a moderator

Re: The aim of WMSYS [message #453180 is a reply to message #452309]

Tue, 27 April 2010 12:10

Amine
Messages: 376
Registered: March 2010

Senior Member

Sorry for the delay and big thanks to Michel

Amine

Report message to a moderator

Re: The aim of WMSYS [message #453677 is a reply to message #452211]

Fri, 30 April 2010 04:50

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Hi Amine

WMSYS user is basically Used to store all the metadata information for Oracle Workspace Manager. This user is locked by default.
The user account is locked because oracle want the password to be public but restrict access to the account to the SYS schema.

So there is nothing that is going to effect the database.

Regards
Deepak

Report message to a moderator

Previous Topic:	Can you truncate TEMPDB tablespace?
Next Topic:	Oracle 9i to 10g upgrade

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 21:34:23 CST 2025