Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coder
Starting Member
16 Posts |
 Posted - 2007-05-13 : 06:41:55
|
| Hi, I have heard that I'm not supposed to use information_schema anymore with SQL 2005 because of security reasons? I was wondering, if I'm not supposed to use information_schema anymore, what is the best way to dynamically come up with a list of the tables in my database? Is there some way to turn this security off? Thanks! |
|
|
coder
Starting Member
16 Posts |
Posted - 2007-05-13 : 06:43:53
|
| I forgot to mention, I tried using "select * from information_schema.tables" and it return a table with zero rows and columns. Is there a setting I need to toggle on or off to be able to view the rows and columns? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-13 : 15:14:24
|
| It still useful, but it only returns objects you have permission on. |
|
|
|
coder
Starting Member
16 Posts |
Posted - 2007-05-14 : 03:35:29
|
| Hi, Thanks for the help. =) I have one more question. How do I set the permissions to allow users to access information_schema? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-14 : 03:45:11
|
| You don't need to give permission to INFORMATION_SCHEMA views, you need to give permissions to underlying tables to view them through INFORMATION_SCHEMA views.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
information_schema.tables still useful?