由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - how to create user in Oracle?
相关主题
请教 oracle sql developer怎么准备第一份DBA工作
Oracle OCM 有多牛?求职Oracle DBA
Oracle DBA position is available in bay area (转载)ORACLE DBA job in Richmond, VA, 求推荐
考古了半天,大家说的db developer和一般的programmer有什么Oracle DBA position at Austin TX
请推荐database的经典书What is default USERNAME and PASSWORD
advices please on learning Oraclehow to know how many uses exists in my db?
Oracle证书一个oracle query, 求问
Recommended Books for oracle beginnersOracle的12位OTN号码???
相关话题的讨论汇总
话题: user话题: create话题: oracle话题: login话题: username
进入Database版参与讨论
1 (共1页)
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!

1 (共1页)
进入Database版参与讨论
相关主题
Oracle的12位OTN号码???请推荐database的经典书
请教: 如何用Perl连接Oracle数据库?advices please on learning Oracle
Oracle question. thanks.Oracle证书
SQL Developer ORA-01017 错误Recommended Books for oracle beginners
请教 oracle sql developer怎么准备第一份DBA工作
Oracle OCM 有多牛?求职Oracle DBA
Oracle DBA position is available in bay area (转载)ORACLE DBA job in Richmond, VA, 求推荐
考古了半天,大家说的db developer和一般的programmer有什么Oracle DBA position at Austin TX
相关话题的讨论汇总
话题: user话题: create话题: oracle话题: login话题: username