Insuffers privilegies

[davidmeloboy]

Good morning, I have a problem with my login screen, I have three user, two DBAs and two print of Oracle, my problem is this, when I'm going to change a DBA user to another dba, I can, but when I'm going to change user of a normal user for a dba of the message that I do not have enough privileges, I could not figure out what privilege I should give

[ruevers]

How to change ??? I think I did not understand ...

When you give a connect sys / password @ base the sysdba gives error ?? Have you tried it?

[davidmeloboy]

Imagine that you are connected to your system, and log off to enter another user! When I do it the problem I put up!

[dr_gori]

What system is this?
SQL * Plus? Any Oracle tool? Or any application any? (Made in Delphi, VB, Java, etc.) ...

If it is the third option, it must be bug in the program - we can hardly be able to help

[davidmeloboy]

Well I'll explain again, this time clearer!
I have an application developed in Oracle Developer 6i, with the Oracle 10G Express database OK?
I have an initial module that is my system login screen!
The command that use to login is

logout;
and then give a login, with the user and password and the right bankname informed by the user.
When I log off and enter with a user who does not have DBA privileges, at the time I log off again and try to enter any other user from the topic of the topic! But I have not yet discovered which privilege is missing for these user who are not DBAs.

[Trevisolli]

Brother,

for these "other" users who are not DBA's, do you have a privilege of Connect and Resource?

[davidmeloboy]

Yes I have yes! To tri acted with this problem!
I think I will delete them and create them again

[dr_gori]

For these "other" users who are not DBA's, do you have a privilege of Connect and Resource?

No need to resource ... Only Connect já served: - /

Is it something even connecting?
or does the forms run anything in the WHEN-NEW-FORM-INSTANCE that is giving this error?

Have you connected with these users (not DBA) direct in forms? (to see if it is not any incompatibility of XE with Developer 6)

[davidmeloboy]

I did not try to do this, straight into the forms only connect with the user who is creating the tables in the bank!
I'll try to do this today to see if some mistake!