close

Error 229: Permissions problem with sysobjects and sysindexes


Solution:
Check to ensure the public role has SELECT permissions on the following:

syscolumns
syscomments
sysconstraints
sysdepends
sysfilegroups
sysfiles
sysforeignkeys
sysfulltextcatalogs
sysindexes
sysindexkeys
sysmembers
sysobjects
syspermissions
sysprotects
sysreferences
syssegments
systypes
sysusers

[Reference]
http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-03/1061.html

 

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 DanBrother 的頭像
    DanBrother

    DanBrother的部落格

    DanBrother 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄