Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Newbie Security Question

Author  Topic  ggroth9 Starting Member 5 Posts Posted - 2001-01-19 : 16:18:12 Need to grant remote access to client to 4 tables in single database on server running SQL 7.0. I have created 4 views pertaining to client specific data. Created login for client in Public group, and added read only permissions to the 4 views. Is there anything else that I need to lock down before giving the client access? I've logged on with username/password. All is working, but it seems that a lot more info is available than I thought would be. I'm not up to speed yet on the system tables, and what damage may be caused by client fooling with stuff he shouldn't be, as it appears that the public group has write access to some of the tables in the dafault database. Thank you for your time. greg