SELECT permission was denied on the object SQL schema ''sys''

• ogyi

  SSC Veteran

  Points: 227

  More actions

  September 18, 2007 at 9:28 pm

  #153839

  Hi ya... I have moved from SQL 2000 to SQL 2005. Using Management Studio SQL 2005, I am able to log in as the user but when I tried to expand the database folder, I get the following error message. "The SELECT permission was denied on the object 'extended_properties',database'mssqlsystemresource',schema'sys'.(Microsoft SQL Server, Error:229)

  Using administrator account,I have given permissions to expand the database for users, but still can't expand it. still got above issue... pls pls reply me anyone who knows.. thanks in advance.. ^_^

• michaela

  SSCertifiable

  Points: 5649

  More actions

  September 18, 2007 at 11:38 pm

  #734470

  use

  master

  go

  GRANT

  VIEW ANY DEFINITION TO user_login;

  go