OraFAQ Forum: Security » changing profile for multiple users

Home » RDBMS Server » Security » changing profile for multiple users (oracle,9i,windows)

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

changing profile for multiple users [message #300459]

Fri, 15 February 2008 08:24

aviana
Messages: 106
Registered: July 2007

Senior Member

Hi,

What command should i use to update the 'profile' for multiple users?I want to change from 'DEFAULT' to another profile for about 40 users...
Which table is it, that I have to update?
I can view the data in DBA_USERS but not sure which table needs to be updated.pls help
Thanks a lot

Report message to a moderator

Re: changing profile for multiple users [message #300462 is a reply to message #300459]

Fri, 15 February 2008 08:43

Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ALTER USER for each user.

Regards
Michel

Report message to a moderator

Re: changing profile for multiple users [message #300467 is a reply to message #300462]

Fri, 15 February 2008 09:07

aviana
Messages: 106
Registered: July 2007

Senior Member

Hi Michel,is there a way to do multiple update,
in a single statement?

Report message to a moderator

Re: changing profile for multiple users [message #300471 is a reply to message #300467]

Fri, 15 February 2008 09:25

Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No.

Regards
Michel

Report message to a moderator

Re: changing profile for multiple users [message #302817 is a reply to message #300467]

Wed, 27 February 2008 01:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

There is no way but you can create .sql script for that.
which run once and update all user (which you need) profile.

Report message to a moderator

Previous Topic:	last password change
Next Topic:	Scott user locked and expired

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 20 19:34:54 CDT 2022