We help IT Professionals succeed at work.

permissions to an user except writing to a database

mcrmg
mcrmg asked
on
111 Views
Last Modified: 2010-03-25
Hi,

I have an ASP and Access DB.  I was wondering if this is doable?  Thanks.


https://www.experts-exchange.com/Security/Win_Security/Q_20937262.html#10714611
Comment
Watch Question

Commented:
As the ASP controls what is read and written to a database its entirely up to you, within your code, what the user can or cannot do. But this will not be something that is done for you, you will have to add all the logic that control this.

Steve

Author

Commented:
The reason I asked is because if I did not check "modify" as permission, the *.ldb files keep showing up (I use Access as db),
if I check modify, *.ldb files disappear when users are done with db

Commented:
The ldb file is just a locking file which I guess is just being used to lock the database to prevent modification in the first instance but in the second disappears once the an update is complete. That is a guess though (although it has just given me a clue to another problem that I have seen!)

Steve

Author

Commented:
You are 100% correct.  The strange thing is it wont go away if I uncheck "modify"

Commented:
>The strange thing is it wont go away
Ever or does it disappear if the application closes. (Edit the global.asa and save it to force the application closed).

Steve

Author

Commented:
Could you provide ex?  Thanks
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Sorry if this is a dumb question.....what should be the value of Application?

Commented:
It doesn't matter the server watches the global.asa file for changes if it changes it closes all he sessions and the application.

Author

Commented:
Okay, so all I do is paste this in asa??  Thanks


<SCRIPT LANGUAGE="VBSCRIPT" RUNAT=SERVER>
SUB Application_OnStart
Application("test")="test"
END SUB
</SCRIPT>

Commented:
yes in a file called global.asa in the root of your web server. When you want to force the application to shut again edit it and save it agains.

Steve

Author

Commented:
Can you gice a ex??  (I do not quite get it...sorry    :(     )

Commented:
I have given you an example above

Author

Commented:
So, Application("test")="test", both must have the same values??  and I do not have to do anthing in onend??  Thanks

<SCRIPT LANGUAGE="VBSCRIPT" RUNAT=SERVER>
SUB Application_OnStart
Application("test")="test"
END SUB
</SCRIPT>

Commented:
It doesn't matter all it is about is change the global.asa file so that the server restarts the application and this way you might see the ldb file close. Just try it
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.