Urgent: two databases different users and passwords
Urgent: two databases different users and passwords
(OP)
Hello,
I'm with a big problem.
1. I have two databases:
blue.gdb
red.gdb
2. Well, when my program start runs I connect to "blue.gdb" and read some registers to load some variables to memory, before login (i need this database here). Then I show the form login asking for username and password. When he press the button I take the user and password and send to database "red.gdb". It works, because user is SYSDBA and password is masterkey.
3. I change SYSDBA password to "bigtest" in my interbase console. The problem is when I run my program it gives me an error: "The user and password is not defined."
4. My question is simple: The users/passwords is for database or for computer databases? And how do I solve my problem?
I'm with a big problem.
1. I have two databases:
blue.gdb
red.gdb
2. Well, when my program start runs I connect to "blue.gdb" and read some registers to load some variables to memory, before login (i need this database here). Then I show the form login asking for username and password. When he press the button I take the user and password and send to database "red.gdb". It works, because user is SYSDBA and password is masterkey.
3. I change SYSDBA password to "bigtest" in my interbase console. The problem is when I run my program it gives me an error: "The user and password is not defined."
4. My question is simple: The users/passwords is for database or for computer databases? And how do I solve my problem?
RE: Urgent: two databases different users and passwords
Did you hard coded the username and password in your application? The users are defined at server level. The sysdba has access to all tables. If you create a new user you must grant him rights inside your database.
Steven van Els
SAvanEls@cq-link.sr