Hi.

I am working with an account that has limited access to the SQL server.
Using Sharepoints API, I am opening a list on a web, and get the following
error.
________
The SELECT permission was denied on the object ‘syscolumns’, database
‘mssqlsystemresource’, schema ‘sys’
________

I now need to find a way to grant this account permission to preforn Select
queries on that database.
The account has Server role 'PUBLIC' only.

the two ways i could think of are :
1) Set a higher server role.
and
2) USE Master GRANT SELECT ON sys.syscolumns TO PUBLIC

But the customer dont want to use those solutions, since it isn't secure
enough.

Any other suggestions on how i can resolve that?
As a note, the mssqlsystemresource is a hidden database that complements the
master db. (it contains stored procedures , views and functions)

> I am working with an account that has limited access to the SQL server.
> Using Sharepoints API, I am opening a list on a web, and get the following
> error.
> ________
> The SELECT permission was denied on the object ‘syscolumns’, database
> ‘mssqlsystemresource’, schema ‘sys’
> ________

I don't know much about Sharepoint but the error indicates that at least
VIEW DEFINITION is required. This permissions allows retrieval of meta-data
related to database objects.

> I now need to find a way to grant this account permission to preforn
> Select
> queries on that database.
> The account has Server role 'PUBLIC' only.

Check out the db_datareader database role. You can also grant permissions
at the schema level. For example:

GRANT SELECT ON SCHEMA::dbo TO SomeAccount

--
Hope this s.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Sigge Persson" <Sigge Persson@discussions.microsoft.com> wrote in message
news:0F470155-EF14-4277-9651-202A592DAA1A@microsoft.com...
> Hi.
>
> I am working with an account that has limited access to the SQL server.
> Using Sharepoints API, I am opening a list on a web, and get the following
> error.
> ________
> The SELECT permission was denied on the object ‘syscolumns’, database
> ‘mssqlsystemresource’, schema ‘sys’
> ________
>
> I now need to find a way to grant this account permission to preforn
> Select
> queries on that database.
> The account has Server role 'PUBLIC' only.
>
> the two ways i could think of are :
> 1) Set a higher server role.
> and
> 2) USE Master GRANT SELECT ON sys.syscolumns TO PUBLIC
>
> But the customer dont want to use those solutions, since it isn't secure
> enough.
>
> Any other suggestions on how i can resolve that?
> As a note, the mssqlsystemresource is a hidden database that complements
> the
> master db. (it contains stored procedures , views and functions)
>

Thanks.
This will probably solve my problem, i'll give it a try tomorrow.

Thanks for the .

"Dan Guzman" wrote:

> > I am working with an account that has limited access to the SQL server.
> > Using Sharepoints API, I am opening a list on a web, and get the following
> > error.
> > ________
> > The SELECT permission was denied on the object ‘syscolumns’, database
> > ‘mssqlsystemresource’, schema ‘sys’
> > ________
>
> I don't know much about Sharepoint but the error indicates that at least
> VIEW DEFINITION is required. This permissions allows retrieval of meta-data
> related to database objects.
>
> > I now need to find a way to grant this account permission to preforn
> > Select
> > queries on that database.
> > The account has Server role 'PUBLIC' only.
>
> Check out the db_datareader database role. You can also grant permissions
> at the schema level. For example:
>
> GRANT SELECT ON SCHEMA::dbo TO SomeAccount
>
> --
> Hope this s.
>
> Dan Guzman
> SQL Server MVP
> http://weblogs.sqlteam.com/dang/
>
> "Sigge Persson" <Sigge Persson@discussions.microsoft.com> wrote in message
> news:0F470155-EF14-4277-9651-202A592DAA1A@microsoft.com...
> > Hi.
> >
> > I am working with an account that has limited access to the SQL server.
> > Using Sharepoints API, I am opening a list on a web, and get the following
> > error.
> > ________
> > The SELECT permission was denied on the object ‘syscolumns’, database
> > ‘mssqlsystemresource’, schema ‘sys’
> > ________
> >
> > I now need to find a way to grant this account permission to preforn
> > Select
> > queries on that database.
> > The account has Server role 'PUBLIC' only.
> >
> > the two ways i could think of are :
> > 1) Set a higher server role.
> > and
> > 2) USE Master GRANT SELECT ON sys.syscolumns TO PUBLIC
> >
> > But the customer dont want to use those solutions, since it isn't secure
> > enough.
> >
> > Any other suggestions on how i can resolve that?
> > As a note, the mssqlsystemresource is a hidden database that complements
> > the
> > master db. (it contains stored procedures , views and functions)
> >
>