script step and passwords

[nbrunskill]

Hi,

I'm tweaking the access levels of a couple related databases. One is a timecard where each entry (via a portal) is a record in a related database. I have a script which is run after a timecard is filled out which goes to the related records, loops through them and performs a the setfield function and a calculation and, lastsly, "sendmail." When I run it as the non-administrator user it says "Your password does able enable you to do this, or this file is not modifiable." I can run this script fine as admin fine and I was able to trooubleshoot the problem to the "Go to related record" script step. I've given the user access to the necessary layout and fields in the related db (though I'd prefer only the script to have access to these), but cannot figure out what is causing the error. Any ideas or other things to double check?

thanks in advance

Nate

[LiveOak]

I would probably throw some pauses into the script or perform the operations manually to narrow the problem down to which scripted operation is failing.

-bd

[djgogi]

If the password (and access privileges) don't allow certain action than it is valid also for the scripts and not only if manually executed by the user.

For ex, if the user password don't allow creation of new records than this cannot be done neither by some script.

As LiveOak suggested you disable error capturing and individuate the offending step. Be aware, however, that, as I said above, if the action is not permitted by the password and access privileges, than it cannot be performed neither by the script.

Dj

[nbrunskill]

Nuts! I really wanted to allow scripts to do things that I didn't want people manually messing with. Is there any workaround for this? I assume I'm not the only one who's wanted to do stuff like this. I tried giving the password access to the fields, but not the layout but that didn't work either. Any ideas?

thanks again

Nate

[Razumovsky]

Hi Nate,

Control access through your layouts and navigation buttons. Allow the non-admin pass to have access to the layout, but remove that layout from the layout menu in browse mode. Set the "available commands" for the non-admin pass to "none", but do not uncheck the edit records or delete records boxes.

[nbrunskill]

Alrighty, I'll give it a go.

thanks!

Nate

[Anatoli]

Hi Nate,

Control access through your layouts and navigation buttons. Allow the non-admin pass to have access to the layout, but remove that layout from the layout menu in browse mode. Set the "available commands" for the non-admin pass to "none", but do not uncheck the edit records or delete records boxes.

IMHO -- I will uncheck the Delete records and allow only admin or manager to delete something.

Much better is to hide status area and run everything from scripts.