christshis
Registered User.
- Local time
- Today, 15:05
- Joined
- May 24, 2006
- Messages
- 14
Hello Guy,
We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front end to access the Trapeze oracle tables.
Due to the possible dangers of allowing the users Access, Is there a way to block the users from changing the oracle tables and only be able in MS Access to create reports and queries? Trapeze's security is antiquated and uses Oracle to validate accessibility. Since a user has to be created in Oracle, with update, delete, read, write, append rights, for Trapeze to work correctly, a user can connect directly to the Db through Access and make changes directly to the data, unless the ability to prevent them from modifying the tables and only create reports and queries that they can save.
We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front end to access the Trapeze oracle tables.
Due to the possible dangers of allowing the users Access, Is there a way to block the users from changing the oracle tables and only be able in MS Access to create reports and queries? Trapeze's security is antiquated and uses Oracle to validate accessibility. Since a user has to be created in Oracle, with update, delete, read, write, append rights, for Trapeze to work correctly, a user can connect directly to the Db through Access and make changes directly to the data, unless the ability to prevent them from modifying the tables and only create reports and queries that they can save.
