I have developed a database that tracks events. I'm setting it up so that we can receive a request for an event and route it up through several people and eventually up to our boss, all electronically within the databse, but I would like to have certain things disabled for certain users. For example:
I want to set it up so that once the boss makes a decision as to whether we'll support the event, an email is automatically sent informing the requesting party of the decision. Now I obviously don't want just anyone to be able to click that button and send and email, so I need to make sure that only the boss can click the button.
So, first, is this even possible, and second, how do I go about doing it without some kind of "user level security"? Is it possible to access the user name logged in to the computer and use that to disable things?