Entry

Database: Microsoft: SQL server: Table: Connect: SELECT permission denied on object <your tablename>

Dec 23rd, 2003 16:14
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 24 December 2003 - 01:05 am -------------------

Database: Microsoft: SQL server: Table: Connect: SELECT permission 
denied on object <your tablename>

---

If you get the message: 'SELECT permission denied on object '<your 
tablename>', <your databasename>', owner 'dbo'

Steps: Overview:

 1. -Goto Microsoft SQL server Enterprise Manager

 2. -Open that table

 3. -Right click

 4. -click button 'Permissions'

 5. -enable checkboxes 'SELECT' (and possibly the other)
     for <your login>

     (e.g. 'DELLI8500\ASPNET')

 6. -click button 'OK'

 7. -click button 'OK'

---
---

Note:

I did find this out by checking a table of the Microsoft
Northwind database, and looking at the permissions for
any public table in that database.

----------------------------------------------------------------------