Home » RDBMS Server » Security » Oracle Security
Oracle Security [message #103272] Wed, 09 April 2003 14:01
Ken Reaves
Messages: 3
Registered: April 2003
Junior Member
Our users utilize MS Access for reporting that queries an Oracle database. When a user links an Oracle table in MS Access, the table row can be updated or deleted. In a attempt to prevent this from happening, I've created a role and granted select on table(many tables) to the role. I then altered the user by making this role the default. This seems to work when connecting via ODBC using Oracle Enterprise Manager, but doesn't when the table is linked via MS Access. I'm open to suggestions as to how to prevent this from happening.
Previous Topic: ROLES/PRIVS
Next Topic: Grant user, role
Goto Forum:
  


Current Time: Fri Sep 17 02:55:24 CDT 2021