Users And Group Permissions

[christshis]

We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front hand to access the Trapeze oracle tables.
Since a user has to be created in Oracle, with update, delete, read, write, append rights, for Trapeze to work correctly
Is there a way for me (, even though the user has update, delete, read, write and append rights via oracle) to limit them to "read" only on the table and not update when they access the database through MS Access to create raports? I would like to allow them to create reports by linking to Oracle tables, but I don't want them to be able to update or delete or change the data in those tables.
They only way I want them to change the data has to be through the Trapeze GUI front hand application.
Any suggestions is greatly appreciated.

Thank you.

 

[ghudson]

You will have to use Access security with a custom workgroup and user permissions. That is the best way to protect the data but allow them to create and save custom queries an reports. But the user should never have access to the database window.

Another option is to force them to open the database in the read-only mode.

Here is an example of how to set the Target: value of a custom shortcut.

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "C:\YourDatabase.mdb" /ro

Set command-line options for starting Access

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

 

[christshis]

You will have to use Access security with a custom workgroup and user permissions. I HAVE NEVER DONE THIS BEFORE. CAN YOU GIVE ME MORE DETAILS ABOUT IT? is the best way to protect the data but allow them to create and save custom queries an reports. But the user should never have access to the database window.(IT THEY CAN'T ACCESS THE DATABASE WINDOWS, HOW WOULD THEY CREATE REPORTS OR QUERIES FROM TABLES?
Another option is to force them to open the database in the read-only mode.
(IF I FORCE THEM TO OPEN THE DATABASE ON READ ONLY. ARE THEY GOING TO BE ABLE TO SAVE THE REPORTS OR QUERIES THEY CREATE?Here is an example of how to set the Target: value of a custom shortcut.
THANKS AGAIN
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "C:\YourDatabase.mdb" /ro

Set command-line options for starting Access

Searching the forum is a great way to discover and learn the answers to your Access programming questions.
__________________
Well if it seems to be real, it's illusion...

I am using Access 2003 with Windows XP

The Search function on this forum really does work. Go ahead, I dare you to try it!