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 |
|
masteripper
Starting Member
25 Posts |
 Posted - 2009-11-18 : 10:05:59
|
| Hi to everybody,i have a problem and after googling i found no anser.The story is :2 Companies physically connected but total different Domains/Subnet but with connection.The 1st company requires some data from the 2nd company (my company)These data are laid on access MDB.So i Created a Linked Server on my SQL 2005 and so far so good.From the SQL Studio with a simple SELECT query i have the data the 1st company needs...and this is what they need NOTHING more...just execute a simple SELECT query to retrieve the Data.The problem is with security.I created a user in order to "give" it to the 1st company to connect to my SQL server.I gave the user dbreader and denywriter role but no matter what he can still do inserts (at least this is what i have tried and is probably the most important).I tried to deny him all (insert,delete,update) but no effect.Well there must be a trick that this user can only connect to my server,and execute my select query.Any idea? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-18 : 10:40:40
|
| make sure user isn't in db_owner role, and not in any server roles.why not just export the data and give it to them? |
 |
|
|
masteripper
Starting Member
25 Posts |
Posted - 2009-11-18 : 12:03:10
|
| I am afraid i can't export the data because they want a continuous flow....and after all is not my desicion.The user is only has dbreader and dbdenywriter....on database master ( idon't know if i can assign these roles to the linked server , i have searched but found nothing). |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-18 : 12:12:04
|
| i'll keep 'em out of the master db |
|
|
|
masteripper
Starting Member
25 Posts |
Posted - 2009-11-18 : 12:40:11
|
| But how to keep them out the master db.The linked server is "attached" to master. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-18 : 12:44:01
|
| change the default db of linked server account.what credentials are being passed to linked server? |
|
|
|
masteripper
Starting Member
25 Posts |
Posted - 2009-11-18 : 13:01:24
|
quote:
Originally posted by russell
change the default db of linked server account.what credentials are being passed to linked server?
I am afraid i haven't heard such a case.I Used the management studio to establish a Linked Server to my Access .mdb.Any info how to do it. |
|
|
|
|
|
|
How ? maximum Security for Linked Server (access)