Networks

Ask something
Question Locked

SQL Server Security

0 helpful
2 replies

by kurt.foster

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have been put in the awkward position of needing to publish our internal SQL Server to the web for a particular client. I also have to provide them with a user name and password to be able to access the database through a software application. They need to be able to execute SP's and do select, insert and update on tables. However I want to restrict them from viewing the database design through Enterprise Manager or similar.
I have restricted their access so they cannot make changes to the database but they can still see the table and SP design which I don't want them to see.

2 replies

by Member 22070467

All you need to do (if you are using 2005) is to deny "View Definition" privledges to that user in the particular schema in the database.

This discussion is closed to new replies.