Accessing metadata

Question

Hi, I will be starting on a project which involves connecting an oracle database to .NET. One of the primary tasks will be to access the metadata of the database and display it in a tree view on a window form. 1) How can I access the metadata through ADO.NET and use it? 2) Is it also possible to access metadata information about primary keys, foreign keys etc.? I will greatly appreciate the suggestions. Thanks in advance. Diya

Answer 1

You have to add authentication + authorization module in your services.
Based on the service context + operation context + user authorization you should be able to restrict the access.

You may need to maintain some kind of roles + users in the database / in configuration xml file to maintain the authorized users list.

Answer 2

Thanks Dude, 
This concept is very usefull for me---

http://www.dotnetcurry.com/ShowArticle.aspx?ID=592