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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-27 : 07:27:17
|
| Kee writes "Hi SQL GuruI have create many sql database around for different application.Now when I required information, I need to query it out from different dbs. Now I have an application that require the data from all the different dbs.But I require it to be the most up-to-date.I created views on the different dbs. I created a intermediate db that has access to all the views using one user login. (so i can use it for other things)I create a db for my new application. This db is pulling data from the intermediate db using a different user login. My structure is something like as below:DB1, DB2|view1a |view2a <-- UserA| |InterDB |viewA, viewB <-- UserB|DB4I have create a view call view1a in DB1, a view call view2a from DB2.Select permission is granted to UserA in DB1, DB2 and InterDB.(UserA is the owner of InterDB)In InterDB, created a view call viewA that is referening from view1a. A view call viewB reference from view2a.DB4 access the views in InterDB by using the login UserB.(UserB is the db owner of DB4)However, I have got a error message saying that my user UserB do not have the rights for DB1 and DB2.I can change the acces to the DB1 and DB2 to UserB so DB4 can query the data.But I planned to make use of the data from the InterDB by other dbs (own by other person) in the future. If I do that, everytime there is a new db, I need to created login in DB1, DB2. So the list of user will grow and I need to open up DB1, DB2 structure to other people. Do you have any good solution that will not reduce the security of the dbs." |
|
|
|
|
|
SQL Ownership Chain