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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Read Only ODBC Connection

Status
Not open for further replies.
cocopud

cocopud

Technical User
Jan 8, 2002
139
US
We have a SQL Server 2000 database that a user wants access to, they want a read only ODBC connection for a few tables.

If they create an ODBC connection to out database, how do I give them access to only three tables and make them read only?
 
Sort by date Sort by votes
Grant them SELECT access to the objects they want to see only.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
719
dhookom
dhookom
Farrukh hameed
  • Locked
  • Helpful tip
Single Connection string control multiple database connection on case condtion
Replies
1
Views
489
fredericofonseca
fredericofonseca
mrmovie
  • Locked
  • Question
ODBC connection, or other from Linus system using AD account details 2
Replies
2
Views
412
mrmovie
mrmovie
mekohler
  • Locked
  • Question
Steps to Set Up Trusted Connection
Replies
1
Views
541
philhege
philhege
AndrewWiggins99
  • Locked
  • Question
Read Only access on a specific table 1
Replies
3
Views
347
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top