Link to home
Start Free TrialLog in
Avatar of mcrmg
mcrmg

asked on

permissions to an user except writing to a database

Hi,

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


https://www.experts-exchange.com/questions/20937262/Assigning-permissions.html#10714611
Avatar of mouatts
mouatts

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
Avatar of mcrmg

ASKER

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
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
Avatar of mcrmg

ASKER

You are 100% correct.  The strange thing is it wont go away if I uncheck "modify"
>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
Avatar of mcrmg

ASKER

Could you provide ex?  Thanks
ASKER CERTIFIED SOLUTION
Avatar of mouatts
mouatts

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mcrmg

ASKER

Sorry if this is a dumb question.....what should be the value of Application?
It doesn't matter the server watches the global.asa file for changes if it changes it closes all he sessions and the application.
Avatar of mcrmg

ASKER

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>
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
Avatar of mcrmg

ASKER

Can you gice a ex??  (I do not quite get it...sorry    :(     )
I have given you an example above
Avatar of mcrmg

ASKER

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>
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