1 Replies - 195 Views - Last Post: 17 September 2018 - 08:55 AM

#1 andrewsw   User is online

  • never lube your breaks
  • member icon

Reputation: 6822
  • View blog
  • Posts: 28,266
  • Joined: 12-December 12

where is 'DataSchemaCollection'

Posted 17 September 2018 - 08:40 AM

I needed to grant SELECT permission on a view and did so with GRANT SELECT ON.... I did so but now get another error:

Quote

Cannot find the object 'DataSchemaCollection', because it does not exist or you do not have permission.


Where is this object, 'DataSchemaCollection'? I cannot find it anywhere. I'm presuming it is a system object somewhere.



As well as hunting through Object Explorer (in MSQLMS) I also attempted:

Select [name] as ObjectName, Type as ObjectType
From Sys.Objects
Where 1=1
and [Name] like '%dataschemacollection%'

Is This A Good Question/Topic? 0
  • +

Replies To: where is 'DataSchemaCollection'

#2 andrewsw   User is online

  • never lube your breaks
  • member icon

Reputation: 6822
  • View blog
  • Posts: 28,266
  • Joined: 12-December 12

Re: where is 'DataSchemaCollection'

Posted 17 September 2018 - 08:55 AM

Nevermind, my colleague found what I needed ;)

GRANT EXECUTE ON XML SCHEMA COLLECTION::dbo.DataSchemaCollection TO SomeRole;

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1