hiding tables in sql server

[Bluemonkey]

how can i hide the system tables in sql server?

thanks for the help

[raf]

What do you mean? Hide them from who? How does ASP comes into play?

[Bluemonkey]

in the program its self, so you when you view the tables in your database you only see the ones that you made not the system tables.

i only posted this here because i thought it would have more to do with the asp people then in the general board. sorry if its in the wrong place.

[raf]

I was just wondering and confused.

Not a MS Server user, but i assume you can set view-edit etc permissions for each table, and for each user or group. I know access suports it, so i presume his bigger brother also supports that. Probably even possible to specifyit at variablelevel.
You can use ASP to do this using the revoke statement (at table level), but it's probably easier to use the build in security-tool.

[Bluemonkey]

Thanks for the help

[Roelf]

- start enterprise server manager
- right click the node representing the server you want to hide databases for
- click option: edit sql-server registration properties
- clear the checkbox with label: Show system databases and system objects
Voila!!

[Bluemonkey]

thank you that is exacelly what i wanted

cheers

[whammy]

Good answer. I was sleeping yesterday, or I would have given the same one. LOL.