Home > Archive > Programming with dBASE > April 2005 > admin rights and db+2.21









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author admin rights and db+2.21
Rick

2005-04-07, 8:01 pm

I have a question that needs an answer as soon as possible. I sent out my app to be installed on a network which usese XP. They are having some problems getting it installed due to user privileges.

My install inno script installs the runtime and bde. Another DB+ program is then run on the workstation to deliver and format the data files to the server.

When you install db+ 2.21 and the bde, should you install as admin login, or does that create access problems for ordinary users?

When my db+ program copies the datafiles and updates them, if the person running the program is admin, does that prevent others from using the files the installer login created on the server?

I assumed the answer to both of these is No, but am beginning to wonder since after install they are having trouble accessing the data files and directories on the server.

I searched the ng for "admin" and "install" and found lots of entries but none that answer these questions for me.

Appreciate any help on this you can give, as my client is starting to get the impression that even the install is a problem with my app.

Thanks,
Rick
Don Skupsky

2005-04-07, 8:01 pm

Well, this is right up my alley.

We have developed an application for clients that includes a shared database
on shared server, plus workstation installations for BDE, Crystal Reports,
activeX's, icons, etc.

We have encountered constant problems with the IT folks who fail to follow
our installation instructions: They must create one directory on the shared
server with full administrator rights for that directory -- read, write,
modify, delete. This is different than have someone with administrator
rights do the installation. Some of our users to have XP servers (and XP
workstations), so we know this can work.

On most "locked down" corporate systems today, someone with administrator
rights will then install your software onto the shared server. And, for most
of our clients, you must have administrator rights to load the various items
onto the workstation.

On the workstation, if there could be multiple users, you need to make sure
that all needed information can be accessed by all users. Since our clients
will have dedicated workstations, this has not been a problem.

____________________
____________
Don Skupsky
Information Requirements Clearinghouse
"Rick" <Sportman7@netzero.net> wrote in message
news:xJi5a46OFHA.444@news-server...
I have a question that needs an answer as soon as possible. I sent out my
app to be installed on a network which usese XP. They are having some
problems getting it installed due to user privileges.

My install inno script installs the runtime and bde. Another DB+ program is
then run on the workstation to deliver and format the data files to the
server.

When you install db+ 2.21 and the bde, should you install as admin login, or
does that create access problems for ordinary users?

When my db+ program copies the datafiles and updates them, if the person
running the program is admin, does that prevent others from using the files
the installer login created on the server?

I assumed the answer to both of these is No, but am beginning to wonder
since after install they are having trouble accessing the data files and
directories on the server.

I searched the ng for "admin" and "install" and found lots of entries but
none that answer these questions for me.

Appreciate any help on this you can give, as my client is starting to get
the impression that even the install is a problem with my app.

Thanks,
Rick


Rick

2005-04-07, 8:01 pm

Don Skupsky Wrote:

> Well, this is right up my alley.


Boy am I glad to hear from you.

> We have developed an application for clients that includes a shared database
> on shared server, plus workstation installations for BDE, Crystal Reports,
> activeX's, icons, etc.


Exactly what I need to do.


> We have encountered constant problems with the IT folks who fail to follow
> our installation instructions: They must create one directory on the shared
> server with full administrator rights for that directory -- read, write,
> modify, delete. This is different than have someone with administrator
> rights do the installation. Some of our users to have XP servers (and XP
> workstations), so we know this can work.
>


Ah, so they actually create a directory and set the rights on it competely open, rather than just logging in as admin to create the dir. My inno scripts actually create the directory. Sounds like I need to tell them after the CD is installed, set the ri
ghts on the main root directory for the app to completely open. Do I understand this right?

> On most "locked down" corporate systems today, someone with administrator
> rights will then install your software onto the shared server. And, for most
> of our clients, you must have administrator rights to load the various items
> onto the workstation.
>


This sounds like it might be their problem, since they install as admin, then the users cannot see the data on the server. Would this mean they could maybe solve their problem by specifically setting the rights on that main root dir of my app to complete
ly open?

Your response also prompts another question. I have an .exe that sits on the server root dir for myapp. You walk to each workstation and run this exe to install it (the bde and runtime) to a workstation. It would be nice if only someone that has a high
er level of security than the average users would be permitted to do this. Do you know if there is a way to do this or is it asking too much.


> On the workstation, if there could be multiple users, you need to make sure
> that all needed information can be accessed by all users. Since our clients
> will have dedicated workstations, this has not been a problem.
>


Just so I am sure I understand, this is a user rights issue in that anyone who logs onto that workstation needs to have access. Just a little confused here. If I have them completely open up the main root of my app on the server, wouldn't anyone using t
hat workstation have full access to the server files, or did I miss something here?

One last question, if I can impose on you. I have set up the app so that the main root has only files that can be readonly, like deo files and graphic images. The only folders that need read/write access rights are all the folders under the root that ho
ld actual data, e.g., N:\myapp\data1, N:\myapp\data2 would need read and write, but N:\myapp would not.

In your experience, would it be fine to set all directories under n:\myapp with full access rights, but restrict the rights to the root n:\myapp in this situation. This would be to prevent users from messing with deo objects. My intention was to allow o
nly someone with better than the usual user rights (maybe not necessarily admin rights) to receive and install deo object files to this root.

Sure is good to get someone that has struggled with these issue before. Really appreciate your help.

Rick


> ____________________
____________
> Don Skupsky
> Information Requirements Clearinghouse
> "Rick" <Sportman7@netzero.net> wrote in message
> news:xJi5a46OFHA.444@news-server...
> I have a question that needs an answer as soon as possible. I sent out my
> app to be installed on a network which usese XP. They are having some
> problems getting it installed due to user privileges.
>
> My install inno script installs the runtime and bde. Another DB+ program is
> then run on the workstation to deliver and format the data files to the
> server.
>
> When you install db+ 2.21 and the bde, should you install as admin login, or
> does that create access problems for ordinary users?
>
> When my db+ program copies the datafiles and updates them, if the person
> running the program is admin, does that prevent others from using the files
> the installer login created on the server?
>
> I assumed the answer to both of these is No, but am beginning to wonder
> since after install they are having trouble accessing the data files and
> directories on the server.
>
> I searched the ng for "admin" and "install" and found lots of entries but
> none that answer these questions for me.
>
> Appreciate any help on this you can give, as my client is starting to get
> the impression that even the install is a problem with my app.
>
> Thanks,
> Rick
>
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com