Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: vivek deodhar
  Where is vivek deodhar?
 SANGLI
 India
 vivek deodhar
 Tags
Subject: RE: Data Base Security
Thread ID: 120452 Message ID: 143255 # Views: 69 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Monday, August 27, 2007 6:42:08 AM         
   


> Hi experts,
>
> Can anyone tell me whether ImpersonateLoggedOnUser() can be used over a network where domains are not used, only workgroup is defined (peer to peer network)?
>
> If yes, what is to be put where "domain name" is to be given?
>
> My detailed problem is posted in my earlier post in this thread.
>
> Thanks,
>
> Vivek
>
>
> Well, I have found a way to use ImpersonateLoggedOnUser() on peer to peer networks having no domains, but workgroups. I am giving it below for someone who may want it, (or perhaps, Bernard might add it in his FAQ?)
>
>
> add line
>
>
#define LOGON32_LOGON_NEW_CREDENTIALS   9

> at the start.
>
> use code something like this for logonuser()
>
>
LogonUser("deodhar","\\\\new","password",LOGON32_LOGON_NEW_CREDENTIALS, LOGON32_PROVIDER_DEFAULT, @nToken)

>
>
> where "deodhar" is user on cmputer "new" who has access to the data folder, "password" is password given to user "deodhar" on computer "new".
>
> You can use this code from any computer in the network and get access.
>
> I have tested this with only Xp sp2. For other types, I think logon_provider options will have to be changed.
>
> Thanks,
>
> Vivek

Goog work Vivek. I have updated the FAQ with your suggestion.

Bernard

** If you see someone without a smile, give em one of yours :) **



COMPLETE THREAD
Data Base Security Posted by Ahsan Rana @ 2/1/2007 8:45:45 AM
RE: Data Base Security Posted by tushar @ 2/1/2007 8:59:56 AM
RE: Data Base Security Posted by Ahsan Rana @ 2/1/2007 12:38:58 PM
RE: Data Base Security Posted by Ken Murphy @ 2/1/2007 1:41:30 PM
RE: Data Base Security Posted by suhas hegde @ 12/20/2007 3:31:55 PM
RE: Data Base Security Posted by Frank Cazabon @ 2/1/2007 1:47:50 PM
RE: Data Base Security Posted by Boudewijn Lutgerink @ 2/1/2007 5:34:56 PM
RE: Data Base Security Posted by Ken Murphy @ 2/1/2007 5:44:05 PM
RE: Data Base Security Posted by Boudewijn Lutgerink @ 2/1/2007 5:46:21 PM
RE: Data Base Security Posted by Daniel Hofford @ 8/26/2007 3:22:47 PM
RE: Data Base Security Posted by William Sanders @ 12/19/2007 6:08:03 PM
RE: Data Base Security Posted by Andy Kramek @ 2/1/2007 11:37:49 AM
RE: Data Base Security Posted by meid lababidi @ 2/1/2007 2:47:49 PM
RE: Data Base Security Posted by Ken Murphy @ 2/1/2007 3:33:42 PM
RE: Data Base Security Posted by Tariq mehmood @ 2/6/2007 4:49:21 PM
RE: Data Base Security Posted by Boudewijn Lutgerink @ 2/7/2007 10:44:54 AM
RE: Data Base Security Posted by Tariq mehmood @ 2/7/2007 1:37:03 PM
RE: Data Base Security Posted by Ken Murphy @ 2/7/2007 2:18:30 PM
RE: Data Base Security Posted by randy loberiano @ 2/27/2008 4:05:13 AM
RE: Data Base Security Posted by Pete Sass @ 2/2/2007 3:24:02 AM
RE: Data Base Security Posted by Bernard Bout @ 2/2/2007 4:18:42 AM
RE: Data Base Security Posted by Pete Sass @ 2/10/2007 7:14:25 PM
RE: Data Base Security Posted by Bernard Bout @ 2/14/2007 5:26:58 AM
RE: Data Base Security Posted by Jamie Osborn @ 3/15/2007 1:06:09 AM
RE: Data Base Security Posted by Naomi Nosonovsky @ 3/15/2007 3:50:17 AM
RE: Data Base Security Posted by Jamie Osborn @ 3/15/2007 3:51:16 AM
RE: Data Base Security Posted by Bernard Bout @ 3/15/2007 9:15:03 AM
RE: Data Base Security Posted by Pete Sass @ 3/15/2007 1:05:09 PM
RE: Data Base Security Posted by Bernard Bout @ 3/15/2007 2:32:10 PM
RE: Data Base Security Posted by Frank Cazabon @ 3/15/2007 7:49:19 PM
RE: Data Base Security Posted by suhas hegde @ 12/19/2007 5:16:28 PM
RE: Data Base Security Posted by Prasad Sakharkar @ 2/2/2007 7:33:51 AM
RE: Data Base Security Posted by Ravi Taxali @ 2/5/2007 9:30:25 PM
RE: Data Base Security Posted by kenan cejvan @ 2/5/2007 1:27:00 PM
RE: Data Base Security Posted by mk sharma @ 3/14/2007 5:35:09 PM
RE: Data Base Security Posted by Ken Murphy @ 3/14/2007 7:26:26 PM
RE: Data Base Security Posted by mk sharma @ 3/15/2007 8:16:54 AM
RE: Data Base Security Posted by tushar @ 3/15/2007 8:29:02 AM
RE: Data Base Security Posted by mk sharma @ 3/15/2007 8:45:45 AM
RE: Data Base Security Posted by tushar @ 3/15/2007 10:45:57 AM
RE: Data Base Security Posted by Ulhas Amrite @ 8/25/2007 10:46:23 AM
RE: Data Base Security Posted by tushar @ 8/25/2007 1:18:26 PM
RE: Data Base Security Posted by Ken Murphy @ 3/15/2007 10:39:44 PM
RE: Data Base Security Posted by Ulhas Amrite @ 8/31/2007 1:31:44 PM
RE: Data Base Security Posted by Ken Murphy @ 8/31/2007 2:30:32 PM
RE: Data Base Security Posted by Jamie Osborn @ 3/15/2007 1:40:16 AM
RE: Data Base Security Posted by Bernard Bout @ 3/16/2007 2:32:21 PM
RE: Data Base Security Posted by vivek deodhar @ 8/22/2007 5:53:35 PM
RE: Data Base Security Posted by Bernard Bout @ 8/22/2007 11:40:41 PM
RE: Data Base Security Posted by vivek deodhar @ 8/23/2007 6:36:34 AM
RE: Data Base Security Posted by vivek deodhar @ 8/23/2007 9:41:35 AM
RE: Data Base Security Posted by Bernard Bout @ 8/23/2007 10:33:37 PM
RE: Data Base Security Posted by vivek deodhar @ 8/25/2007 7:16:50 AM
RE: Data Base Security Posted by Bernard Bout @ 8/27/2007 6:42:08 AM
RE: Data Base Security Posted by vivek deodhar @ 2/27/2008 5:31:57 AM
RE: Data Base Security Posted by Bernard Bout @ 2/29/2008 6:24:47 AM
RE: Data Base Security Posted by Binod Binani @ 3/15/2007 7:03:46 PM
RE: Data Base Security Posted by Kip Dole @ 12/18/2007 4:42:43 PM
RE: Data Base Security Posted by Bernard Bout @ 12/19/2007 5:53:27 AM
RE: Data Base Security Posted by Cetin Basoz @ 12/19/2007 11:40:39 AM
RE: Data Base Security Posted by Joe Estrella @ 1/9/2008 8:37:27 AM