Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Micros RES 4.0 Database Password
- Thread starter dennislv
- Start date
In Version 4.0 you need to setup all passwords in DM. These do not carry over for previous versions. You will need to open DM and setup the passwords for any connection you might want to use. Remember, you control the DBA password...this part of the encryption requirement. So if you can it be careful, you will not be able to restore or modify a db without it.
- Thread starter
- #3
- Thread starter
- #4
dennis,
When you upgrade from a previous version all the db users and their permissions are brought over, but the passwords are set to null. Just use the Database Manager to change them to the passwords you want. The caedc user is just the first user alphabetically, so that's what shows in the box when you open it up.
One potential pitfall occurs when you start with a new 4.0 db instead of upgrading. You can add users, but they're all read-only. You can probably log into sybase central as dba and change the permissions, but that can turn into a mess.
Micros added a feature in sp 1 that requires you to enter the old dba password before it can be changed.
There's also an option to reset defaults in the restore database area if you really bang things up and lose all access.
What tables are you looking to write to? Micros has always let the custom user and members of the definition group modify the _def tables but not the _ttl tables.
pat
When you upgrade from a previous version all the db users and their permissions are brought over, but the passwords are set to null. Just use the Database Manager to change them to the passwords you want. The caedc user is just the first user alphabetically, so that's what shows in the box when you open it up.
One potential pitfall occurs when you start with a new 4.0 db instead of upgrading. You can add users, but they're all read-only. You can probably log into sybase central as dba and change the permissions, but that can turn into a mess.
Micros added a feature in sp 1 that requires you to enter the old dba password before it can be changed.
There's also an option to reset defaults in the restore database area if you really bang things up and lose all access.
What tables are you looking to write to? Micros has always let the custom user and members of the definition group modify the _def tables but not the _ttl tables.
pat
- Status