T*******x 发帖数: 16 | 1 I try to login SQL*Plus and was asked to provide username
and password.
I have set myself as DBA and OPR of database, but it seems I
can not use that
username and password to log in.
How can I create a user and login?
Thank you very much! | o*b 发帖数: 42 | 2 If you just installed this db, you can use:
sys/change_on_install or system/manager to login.
If you are in the dba group, you can use "connect internal" to get in.
Once you can log in using the above methods, use something like
"create user your_id ..." (I forgot it, find it in sql reference) and
then grant some privilidges to your id.
【在 T*******x 的大作中提到】 : I try to login SQL*Plus and was asked to provide username : and password. : I have set myself as DBA and OPR of database, but it seems I : can not use that : username and password to log in. : How can I create a user and login? : Thank you very much!
| p**v 发帖数: 7 | 3 Did you grant session to user? Seems you didnt...:)
【在 T*******x 的大作中提到】 : I try to login SQL*Plus and was asked to provide username : and password. : I have set myself as DBA and OPR of database, but it seems I : can not use that : username and password to log in. : How can I create a user and login? : Thank you very much!
|
|