November 23, 2010 at 1:01 am
Hi All,
I no longer able to select from INFORMATION_SCHEMA.TABLES. What kind of privelege I need to have.Please I have DB_DATAREADER permissions already.So mention what permission i need to have
November 23, 2010 at 1:15 am
As far as I know everyone has permissions on those views, but you can only see tables that you have permissions to work with. When you say that you are no longer able to select from this view – do you get an error message? Does it work but you get an empty result set?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 23, 2010 at 1:21 am
Hi,
I am getting empty result set.
Thanks
November 23, 2010 at 3:49 am
Can you make sure that your user can actually work with those tables? Maybe the user is also part of role that has deny permissions on the tables. In any case of permission conflict, the deny permission takes effect, so if a user belongs to both roles db_datareader and db_denydatareader, he won’t be able to see any tables when he’ll run select query on information_schema.tables (assuming that he doesn’t have other permissions on any of the tables).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply