getting permission from server to access infromation_schema

[madhubharathi anbu]

hi,

"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='databasename'"

I want to execute this query.

but my server didnt give the permission to access it.

the error is

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

Access denied for user 'databasename'@'%' to database 'information_schema'

/v1/controls/search3.asp, line 14


What is alternative way to access or how to get the permission for it.

Thnks