Information Schema Views in SQL Server 2005

hi

i having minor problem sql server 2005.

i have requirement users (developers) should have visibility of schema information using either management studio, or application...

the problem when query on information schema views (from accounts have db_datareader , db_datawriter , public role membership) the column_default value not returned, (a null value returned) if there definately default value constraint.

what permisions have give these individuals, dbo not option should have restriceted access database.

i forward answers.

kind regards

 

ronnie

the minimum permission required view default information table column is "alter" permission on table.

of course, alter means principals permission can alter table schema or drop table. if wish restrict , want principals view table schema including definition of default constraint grant them "view definition" permission on table.

please refer topic "metadata visibilty configuration" in books online explains in greater detail.

http://msdn2.microsoft.com/en-us/library/ms187113.aspx

hope helps

thanks

asvin

SQL Server  >  SQL Server Database Engine