Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to create a user for a database

Kumar_9985Sep 13 2012 — edited Sep 14 2012

hi all,

in the default ORCL database (oracle 10g) how can i create a new user. i did the below steps.

1. connecting as sysdba and creating a user

2. create user kumar identified by kumar;
3. create connect,resource to kumar.

but after this when i tried to connect the ORCl database with user 'kumar' it is giving me the ora-01017 error.

please help me how to create a user to a db using sqlplus.

Thanks,
Kumar.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2012

Added on Sep 13 2012

#database, #dba, #general-database-discussions, #sql

9 comments

1,006 views