| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Insert or Update Microsoft Access |
« View previous topic :: View next topic » |
| Author |
Message
|
| kirankinnu |
 Posted: Wed Mar 17, 2010 10:49 am Post subject: Insert or Update Microsoft Access |
 |
|
Centurion
Joined: 12 Jun 2004
Posts: 128
Location: Chicago, IL
|
Hi,
Has anyone integrated Message Broker with Microsoft Access. One of our client uses Microsoft Access and we would have to update that. Are there any support pacs or Utilities available for this.
One other question I have is, Can we impersonate the UserId and Pwd that we send to other interface. Like for example, when I write a file to a directory, broker uses its Userid for accessing the folder its writing to. Broker UserId Does not have permissions on that folder. Within the flow can i change the Broker Userid to some other userid which has Folder permissions.
Thank you for the support,
Kiran |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Mar 17, 2010 12:28 pm Post subject: Re: Insert or Update Microsoft Access |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kirankinnu wrote: |
| Has anyone integrated Message Broker with Microsoft Access. One of our client uses Microsoft Access and we would have to update that. Are there any support pacs or Utilities available for this. |
I'd be surprised and interested to discover WMB had supported drivers for something that desktop... 
| kirankinnu wrote: |
| One other question I have is, Can we impersonate the UserId and Pwd that we send to other interface. Like for example, when I write a file to a directory, broker uses its Userid for accessing the folder its writing to. Broker UserId Does not have permissions on that folder. Within the flow can i change the Broker Userid to some other userid which has Folder permissions. |
Why would you expect anything (WMB, ftp, etc) to be able to write to a directory to which it has no authority? AFAIK you can't set this information in a FileOutput node & it would be a security exposure if you could. Why not just authorise WMB to write to the folder?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| kirankinnu |
| Posted: Wed Mar 17, 2010 12:32 pm Post subject: |
|
|
Centurion
Joined: 12 Jun 2004
Posts: 128
Location: Chicago, IL
|
| Quote: |
| [Why would you expect anything (WMB, ftp, etc) to be able to write to a directory to which it has no authority? AFAIK you can't set this information in a FileOutput node & it would be a security exposure if you could. Why not just authorise WMB to write to the folder?] |
Its the Clients request that we use a specific UserId to access a Folder and the folder cannot be made public.. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Mar 17, 2010 1:09 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| kirankinnu wrote: |
| Quote: |
| [Why would you expect anything (WMB, ftp, etc) to be able to write to a directory to which it has no authority? AFAIK you can't set this information in a FileOutput node & it would be a security exposure if you could. Why not just authorise WMB to write to the folder?] |
Its the Clients request that we use a specific UserId to access a Folder and the folder cannot be made public.. |
Works very well with the correct permissions. Nobody said anything about making it public. Just give the broker's service Id the necessary rights to access the folder 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Mar 17, 2010 1:10 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kirankinnu wrote: |
| Quote: |
| [Why would you expect anything (WMB, ftp, etc) to be able to write to a directory to which it has no authority? AFAIK you can't set this information in a FileOutput node & it would be a security exposure if you could. Why not just authorise WMB to write to the folder?] |
Its the Clients request that we use a specific UserId to access a Folder and the folder cannot be made public.. |
I didn't say public, I said authorise the specific user that WMB is using. It doesn't even need read access....
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
