logo
Redian新闻
>未名空间
>Database - 数据库
>
how to create user in Oracle?
avatar
how to create user in Oracle?# Database - 数据库
T*x
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!
avatar
o*b
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!
avatar
p*v
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!
相关阅读
入门问题：如何在数据表中插入数据。Where to download free MySQL bookOracle 安装创建 DB 请教DSN-less connection to SQL server[转载] Where can i get this?Help need on writing data to Oracle CLOB!FileMaker Prolink website to databaseHELP!! How to run SQL Server 7 in my local computer?How to "CREATE VIEW" by using JDBC? ThanksHow to create a new database under SQL 7.0 from remote host?[转载] 新手求教:DATABASE编程的入门MS SQL server or PostgreSQL server?数据库问题求解data mining tools? helpHow to transfer values between forms in Access?HELP!! How to run SQL Server 7 in my local computer(Windows2000)?[转载] ASP问题： Operation must use an updateable queryRe: How to change Default Buffer Size for Long Columns?(string size exceeds 1K)lost half years post?
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。