:(

229:[Microsoft][SQL Server Native Client 10.0][SQL Server]The SELECT permission was denied on the object 'V_ProductPropertyInfo', database 'artproduct', schema 'dbo'. [ SQL语句 ] : SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [V_ProductPropertyInfo] WHERE ( ProductStatus=1 and ProductType=3 and Status=1 and ProviderId=10000 and BrandId=7 ) ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1)

错误位置

FILE: E:\web\pre.yushibao.com\ThinkPHP\Library\Think\Db\Driver.class.php  LINE: 351

TRACE

#0 E:\web\pre.yushibao.com\ThinkPHP\Library\Think\Db\Driver.class.php(351): E('229:[Microsoft]...')
#1 E:\web\pre.yushibao.com\ThinkPHP\Library\Think\Db\Driver.class.php(181): Think\Db\Driver->error()
#2 E:\web\pre.yushibao.com\ThinkPHP\Library\Think\Db\Driver.class.php(947): Think\Db\Driver->query('SELECT T1.* FRO...', false)
#3 E:\web\pre.yushibao.com\ThinkPHP\Library\Think\Model.class.php(970): Think\Db\Driver->select(Array)
#4 E:\web\pre.yushibao.com\ThinkPHP\Library\Think\Model.class.php(227): Think\Model->getField('COUNT(*) AS tp_...')
#5 E:\web\pre.yushibao.com\Application\Home\Controller\CategoryController.class.php(56): Think\Model->__call('count', Array)
#6 E:\web\pre.yushibao.com\Application\Home\Controller\CategoryController.class.php(56): Think\Model->count()
#7 [internal function]: Home\Controller\CategoryController->index()
#8 E:\web\pre.yushibao.com\ThinkPHP\Library\Think\App.class.php(173): ReflectionMethod->invoke(Object(Home\Controller\CategoryController))
#9 E:\web\pre.yushibao.com\ThinkPHP\Library\Think\App.class.php(110): Think\App::invokeAction(Object(Home\Controller\CategoryController), 'index')
#10 E:\web\pre.yushibao.com\ThinkPHP\Library\Think\App.class.php(204): Think\App::exec()
#11 E:\web\pre.yushibao.com\ThinkPHP\Library\Think\Think.class.php(120): Think\App::run()
#12 E:\web\pre.yushibao.com\ThinkPHP\ThinkPHP.php(97): Think\Think::start()
#13 E:\web\pre.yushibao.com\index.php(27): require('E:\\web\\pre.yush...')
#14 {main}