need access levels to access database

hi ,

i am doing project with jsp in ms-access database. this webapplication should be accessible to 10 people. all should be view the data but levels should be there.how can i get the access levels to the database like reading access to some 2 people. writing and modifying access to some 5 people.inserting can be done by other 2 people . please give the solution for this. i have netbeans4.1 ide , and tomcat bundled server.

so, kindly give the jsp code and msaccess solution.

thanks .

[513 byte] By [dharammaa] at [2007-10-2 0:21:32]
# 1

I am not informed if the ms-access DB supports SQL-92. In that case you should be able to define the users and set the rules using GRANT sql command. So it is more or less an off topic entry here for a java forum.

Else if you try to implement the authoization business logic out of your DB domain in java (or C or whatever), it is no more coupled with the DB and most likely that is not what you are supposed to deliver.

babakNa at 2007-7-15 16:23:02 > top of Java-index,Security,Other Security APIs, Tools, and Issues...