Setting up a read-only tables

scra · May 17, 2005

I share a database to other front-end users. I want to be able to setup the data tables so that the users CANNOT make any changes (add/delete) to any of the data tables. They would still be able to run queries from them. How can this be accomplished?

fredericofonseca · May 17, 2005

what database system?

A proper database like SQL Server or Oracle or DB2 will allow you to setup permissions on each table for each user or role.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

scra · May 17, 2005

It is in Access2000.

fredericofonseca · May 17, 2005

Go to your msaccess help system, and on the answer wizard type "security" and search for it. It will give you all information you need.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Setting up a read-only tables

scra

Technical User

fredericofonseca

IS-IT--Management

scra

Technical User

fredericofonseca

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor