forum.vdsworld.com

Estas

Hi all,
with all the talk going on about VDS6 and Vista right now, I need some help with a technical problem concerning access priviledges.
I have an application which uses a database file. The program has been installed using a freeware setup application by an user with administrative priviledges. Now other users need to make changes to the database as well but Windows won`t let them. The Program is run under a Windows XP Home system. How can I configure either the Setup or the main application which uses the database in that way so every user can access it and make changes to it?
Greetings Mike

jules · Posted: Sun Oct 08, 2006 9:55 am Post subject:

You can set rights using the CACLS.EXE program in Windows. You might be able to do this from the installer. Alternatively if you are using Inno Setup then as Prakash mentioned in one of his postings, there is an option in that which can be used to set access rights.

In the past I've just given Everyone all rights to a folder, which means that they can create, write to and delete files in it. If you only grant the rights after the database files have been installed in the folder, then I think you will have to set the rights to the files as well. Otherwise they will inherit the rights you set for the folder.

Estas · Posted: Sun Oct 08, 2006 11:14 am Post subject:

Thanks for the quick reply,
well, XP Home edition and cacls.exe doesn't work.
and installing the app in the common user folder won't work either.
Only users with admin rights can use the program as intended - other users with limited accounts can't. This is driving me nuts...

jules · Posted: Sun Oct 08, 2006 2:24 pm Post subject:

Even in the All Users folder you have to set permisions for who can access it.

I just run the VDS command:

runh cacls.exe @chr(34)%%appdata@chr(34) /E /G BUILTIN\Users:F,wait

where %%appdata contains the folder path. I don't know why that wouldn't work under XP HOme.

Aslan · Posted: Sun Oct 08, 2006 3:12 pm Post subject:

cacls should work with XP Home Edition however, I don't think it comes with cacls.exe as XP pro does. I don't have Home Edition so I can't confirm this.

You should be able to get a copy of cacls.exe from an XP Pro machine. I don't know what the legallity of redistributing it would be.

Estas · Posted: Sun Oct 08, 2006 3:54 pm Post subject:

Well thanks again,
but thats been the problem all the way:
I need something that allows any user on multi-user systems, (not my pc - but the end-users pc) to make changes to a file (database file).
And if cacls.exe is not distributed with XP Home, it won' help the end-user if I add a command using cacls.exe - even if I have it installed on my pc.
I can't ask a potential customer using XP Home to get cacls.exe nor can I provide it along with the application.

jules · Posted: Sun Oct 08, 2006 4:18 pm Post subject:

CACLS.EXE is included in XP Home, as typing its name from a command prompt would confirm. There is no other way to set access rights from a command prompt.

However if, as I said before, you can set the rights during installation, then you can get the installer to do it.

Garrett · Posted: Sun Oct 08, 2006 7:19 pm Post subject:

CACLS.EXE is included with the XP MCE version.

-Garrett

PGWARE · **Web Host** Joined: 29 Dec 2001 Posts: 1566

CALCS is included in XP Home. I use XP Home and it shows up here when I test it from the command prompt.

Aslan · Posted: Mon Oct 09, 2006 2:50 am Post subject:

Estas,

Estas · Posted: Mon Oct 09, 2006 6:04 pm Post subject:

Hi all,
after checking a different version of XP home, I realized that Cacls.exe IS part of the OS. I didn't know for sure, since I am using a modified version of XP Home on my computer.
And Cacls.exe didn't work on my pc because I was running a third party security program that prevents setting administrative rights the regular way. I am sorry for troubling you guys - but thanks anyway. It helped solving this problem of mine.
Greetings and thanks again...
Mike