Thursday, March 1, 2012

The select permission was denied on the object database schema 'dbo.office'


Use 'Database Name'
Go
GRANT SELECT
ON 'Table Name'

TO public
GO 


For Example:
USE master
GO
GRANT SELECT
ON Office
TO public
GO

0 comments:

Post a Comment