Users, Profiles, Roles and Passwords

[EliseFreedman]

Im a little confused at the moment.

Im creating a student record system using Oracle.

Ive created a tutor role which currently doesnt have a password. I used the following code to create the role
Ive given the role rights to connect to the database

create role TutorRole;
grant connect to TutorRole;

Ive created a tutor profile using the following commands

create profile "TutorProfile" LIMIT
failed_login_attempts 5
password_lock_time 10/1440;

finally Ive created a tutor user account which uses the tutor role and profile.

CREATE USER "TUTOR"  PROFILE "TutorProfile" 
    IDENTIFIED BY notidentified; 
  
Grant TutorRole to Tutor;

This code all seemed to work ok when i was running it. However, I am now trying to login as the tutor user.

However, I keep being asked for a password and when i dont enter anything and hit enter, I get the following error message

ERROR:
ORA-01005: null password given; logon denied

It then tells me that im no longer connected.

What, if anything am I doing wrong?

 

[SantaMufasa]

Elise,

What happens if you try to connect to TUTOR with a password of "notidentified"?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[EliseFreedman]

Ive just done that (before you posted) and ive managed to connect now. Just means im even more confused.

I thought the IDENTIFIED BY notidentified clause meant that a password hadn't been set. How do I create a user without assigning a password;

 

[SantaMufasa]

Purchase MS Access.

Just kidding...

Read up on "...IDENTIFIED EXTERNALLY..." That will be the closest you can come, I believe.

Let us know what you decide to do.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.