April 21st, 2004, 07:24 PM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 6
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Setting access levels in Oracle
I would like to know what is the best way to set up my tables so that i can control access levels to table information. For example i wish to have a membership table containing member details. I want a member to only be able to VIEW their details and no one esle's.
In addition to this i would like one particular member (Myself) to be able to VIEW, ADD, UPDATE, and DELETE all member details. Is it best to have a login table aswel as a member table, or should i merely have a member table with login details contained within this table?
Or as the database will be connected to my website where this information will be viewed, would it be best to set the access levels at web level? i will be using JSP if that helps.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
