| DATABASE PASSWORD [message #166590] |
Fri, 07 April 2006 02:41  |
aparnapallavi
Messages: 28
Registered: June 2005
|
Junior Member |
|
|
i want to set password at the schema level. i know that creating a password at the time of creation of the database can be done, but cannot manage to set a password for a schema which exists for some time now.
|
|
|
|
| Re: DATABASE PASSWORD [message #166601 is a reply to message #166590] |
Fri, 07 April 2006 03:36  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
Hi. Just to clarify, you set passwords for users.
To set a user's password:
ALTER USER username IDENTIFIED BY new password.
Jim
|
|
|
|
|
|
| Re: DATABASE PASSWORD [message #166636 is a reply to message #166612] |
Fri, 07 April 2006 06:06 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
hehe,
>>i dont want password to be set at user access level but at the database access level
What do you mean by user access and database access?
Paraphrasing another contributor in this forum
| Quote: |
a user and schema are one and the same for all practical purposes
|
Are you looking into a restriction where users are not allowed to change their passwords?
[Updated on: Fri, 07 April 2006 07:27] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
