Home » RDBMS Server » Security » changing profile for multiple users (oracle,9i,windows)
changing profile for multiple users [message #300459] Fri, 15 February 2008 08:24 Go to next message
aviana
Messages: 92
Registered: July 2007
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
Re: changing profile for multiple users [message #300462 is a reply to message #300459] Fri, 15 February 2008 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER USER for each user.

Regards
Michel
Re: changing profile for multiple users [message #300467 is a reply to message #300462] Fri, 15 February 2008 09:07 Go to previous messageGo to next message
aviana
Messages: 92
Registered: July 2007
Member
Hi Michel,is there a way to do multiple update,
in a single statement?
Re: changing profile for multiple users [message #300471 is a reply to message #300467] Fri, 15 February 2008 09:25 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: changing profile for multiple users [message #302817 is a reply to message #300467] Wed, 27 February 2008 01:43 Go to previous message
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.
Previous Topic: last password change
Next Topic: Scott user locked and expired
Goto Forum:
  


Current Time: Tue Sep 23 16:18:15 CDT 2014

Total time taken to generate the page: 0.12116 seconds