You could have your scripts ask for the password to be input, although you probably don't want to do this for public pages.
What you should do is create a user with select only privleges and use that user in all of your public pages, and create another user who has full privleges and make your insert/update/delete scripts ask for the password to be input and pass that around in a session. That way your all access password isn't stored on the system.