July 29, 2002 at 12:33 pm
Hope this does not sound too stupid.
I have a database that lives on a partition called F: on an NT 4.0 server.
The share permissions for the partition are everyone full control.
I use NT authentication to secure the database.
Would it be a good idea to limit the share permissions? Do the database users need full control?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
July 29, 2002 at 12:52 pm
Not a dumb question at all. No one needs share or file access on the drive except the account that SQL runs under. Definitely remove everyone and add back the SQL account and maybe Domain Admins. Recommend you make the changes after hours and test!
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply