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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to set up user READ only permission 1

Status
Not open for further replies.
bloomlight

bloomlight

IS-IT--Management
Jun 12, 2006
149
US
I have an user who would need READ only permission. The user would only need to access database and select data for reporting purpose. How to set up that?

I gave the user "public & db_datareader" permissions. But when I login as the user, I could still get into table area. Will the user be able to do anything with the tables? I wanted to make sure that nothing would happen to the tables. Please help!!!
 
Sort by date Sort by votes
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
183
dhookom
dhookom
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
183
dgillz
dgillz
torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
164
torquinian
torquinian
dgillz
  • Locked
  • Question
SQL Server timeouts after updating workstations to Windows 10
Replies
0
Views
174
dgillz
dgillz
Triacona
  • Locked
  • Question
How to broadcast data from a SQL server to an IP an Port 2
Replies
5
Views
172
fisheromacse
fisheromacse

Part and Inventory Search

Sponsor

Back
Top