Hey I'm making a database for a school project, and basically when you open up the database file I want it to ask for a username and password. And some people get full control over it (they can edit text and numbers, etc) and others can only view it.
For example if I login in as "Admin" I want to be able to edit everything, but if I login as "John" I want to make it so you can only view stuff.
While we are on the security topic.. is there anyways I can restrict the number of times someone can search the database? I don't want someone searching like 100 times and just collecting info. So if the database gets searched like 20 times in under 5 minutes, can you make it cut them off?
Help is much appreciated!! Thanks
Also I've been reading posts and forums about this for a couple hours, but I really havent found any good step by step guides on how to do it.