Hi All, For SQL 2000:
When the user open the database>> Tables, under tables it shows a list
of all the ado/sys tables.

If user choose one of the table name and right click, there is an
option shows the "Design Table". How can we disable that options so
that the user can't choose that option. So if the client link their
database server to our database, they can't view the table design.

Any tips are appreciated.

Cheers.

Kk

Hi, a normal user doesn=B4t have that option, he must be in the dbowner
or db_ddladmin role for that.
Make sure you didn=B4t give him that role credentials.


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---