Oracle Forms

Hello friends... I am trying to give different access to users and allow them to login when i run the forms. However when I run the form and it calls the ON-LOGIN and I enter the new user and password it doesnt log me in. Only one username works and that is the original SCOTT where the tablespaces are.

Am I missing something ??

Apart from the ON-LOGIN trigger, this is what i done:

I created

Create role Manager;

create user Daniel identified by chosenpassword;

Grant Manager to Daniel;

Grant select on Client to Manager;
Grant update on Client to Manager;
Grant delete on Client to Manager;
Grant insert on Client to Manager;

Message was edited by:
Baraka