Programitically set windows user group permissions

[sylhouseal]

Hi, I am looking for a way to programitically set windows user group permissions. I have been able to add the windows user group to Active Directory, but have been unable to locate any documentation on automating security for sql databases and ntfs files. What I have found are software packages for sale.

Any direction would be greately appreciated.

Sylvia

 

[drew1701d]

What permissions are you trying to set? folder access permissions? restricting who can launch a specific program? If thats what your referring to then you need to create a group policy object and link it to your user groups OU

"I'm certifiable, not certified. It just means my answers are from experience...not a book

 

[sylhouseal]

We are setting up a security system that saves Projects, Project Roles, Windows User Group Names.

Once everything is saved in the databases the windows user group name is added to active directory. Now permissions need to be set up on the role objects.

Example:

I want user group (Exam_Processing)to have permissions to:

a view vExam_Processing_data
a stored procedure sp_Exam_Processing_Update
sp_Exam_Processing_Insert
and a folder on \\cs-leo\Examination\Processing_Reports

I would like my program to insert the permissions on the view, stored procedure, and folder programatically.