Forum Post: RE: root authentication

Status
Not open for further replies.
P

pittman

Guest
Hi, The passwords used by OpenEdge sql are independent of the passwords used by the OS. From what you describe, it seems that your db have 3 users defined in the database user table (_User). "a", "b", and "root". Each of these users have a password defined in the OpenEdge user table (encrypted). If you know none of those passwords, then you need to contact a DBA or someone who has the authority to do database administrative actions. That person can create a new user id for your use. After doing so, that authorized person also has to use OpenEdge sql to use the sql GRANT statement to give you the type of privileges you should have. That authorized person could also change the password of an existing user, and then safely tell anyone employing that user id what the new password is. hope this helps, ......sjp [OE sql architect]

Continue reading...
 
Status
Not open for further replies.
Top