Welcome to MSDN Blogs Sign in | Join | Help

March 2008 - Posts

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

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: see here for Read More...
Posted Thursday, March 20, 2008 3:45 PM by b.frank | 0 Comments

Attachment(s): make user owner of db during creation.jpg

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

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 isolation Read More...
Posted Tuesday, March 18, 2008 6:22 PM by b.frank | 1 Comments
 
Page view tracker