faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

40 of 61 people (66%) answered Yes
Recently 5 of 10 people (50%) answered Yes

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.
----------------------------------------------------------------------