Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-06-20 : 18:03:17
|
| Everytime I refresh a database, I have developers/testers login issue.1. When we create a copy (Dev db) on dev server from Prod backup prod db on production server) and run sp_fixusers (Dev db) to sync up db users and logins, what password should we use to get into dev database? The Dev db server login one or Prod db server login? Does the restore from a backup also restore syslogins table? But it is a master table?2. So what happens? Say my password for production db on Prod server is 'ABC123'. and my password for Dev db on dev server is 'DEF456' When I overwrite Dev db with fresh production backup? What should be the password and Why?3. Another point I want to confirm is that the only way I can have multiple userid/passwords for multiple databases is by having multiple server logins. Right?5. Or is there any application which magically lets you have different passwords for different dbs on the same server? I am refering to PeopleSoft 7.5.Thanks.Sarat |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-06-20 : 20:00:54
|
| 1) If you're running sp_fixusers you should probably be logged into the server as a sysadmin. I presume you have such authority on your personal login. Do NOT use SA!2) Logins and passwords are specific to the server, not the database. Assuming you're not restoring one of the system databases like master or msdb, then your login on the Dev server is separate from the one on the production box. The passwords should not be affected by a backup/restore.3) Yes, passwords are tied to logins. Then, database users are mapped to logins. Just because you can login to the server does not mean that you can access a database.5) What happened to 4? I don't know anything about PeopleSoft, but what I have described above is your basic security in SQL Server. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-21 : 07:58:39
|
| 4/5?!?) Peoplesoft uses it's own user table for each database. This is why you can have different pwds to the same sql server...PeaceRick |
|
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2002-06-21 : 13:08:59
|
| Rick,I understand the functionality of OPERDEFN table of peoplesoft butare you saying we can have multiple PSoft db passwords on sql server with single OPRID?So OPRID - TESTUSR can have differernt passwords for Dev Db and Test Db if Dev and Test Db reside on same server?How? It never worked for me!ThanksSarat. |
|
|
|
|
|
|
sp_fixusers / backup restore doubts