Options

Archive

Archives

March, 2008

Posts

| |

|

Bernhard Frank's WebLog

SQL server - a db user should only see his DB and no other.

Posted over 4 years ago

by Bernhard Frank
- 0 Comments
1) You got to remove the VIEW ANY DATABASE permission for the public group. (T-SQL) USE master Deny VIEW ANY DATABASE to public 2) to let the user see his database you must make this user the owner of the db when you create the database: ...
Bernhard Frank's WebLog

use icacls to apply read and execute permissions for "This folder, subfolder and files" (e.g. for IIS7 App Pool Isolation)

Posted over 4 years ago

by Bernhard Frank
- 1 Comments
icacls C:\inetpub\wwwroot\mysite\ /grant:r "IIS APPPOOL\mywebsitepool":(OI)(CI)(RX) guarantees that new files & directories put into this folder inherit the permissions that were set for the parent folder. More details on IIS7 Application pool...