C#

<br />
// This program, which must be run as an Administrator, gives a specified non-Administrator user<br />
// start and stop capabilities on a specified service.  It is intended to be run on systems like<br />
// Windows 2003 SP1 that restrict non-Administrator users from doing things with services.<br />
<br />
// Note that the changes to the services' ACLs only last as long as the service is installed.  If<br />
// you uninstall and reinstall a service, you must rerun this program.<br />
<br />
// This program is a modified version of software provided by Microsoft at<br />
// http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dllproc/base/modifying_the_dacl_for_a_service.asp<br />
<br />
#include <windows.h><br />
#include <aclapi.h><br />
#include <stdio.h><br />
#include <tchar.h><br />
<br />
void DisplayError(DWORD dwError, LPTSTR pszAPI)<br />
{<br />
   char szMessageBuffer[2048];<br />
   FormatMessage(FORMAT_MESSAGE_FROM_SYSTEM,<br />
                 NULL, dwError,<br />
                 MAKELANGID(LANG_NEUTRAL, SUBLANG_DEFAULT),<br />
                szMessageBuffer, sizeof(szMessageBuffer), NULL);<br />
<br />
   // Display the string.<br />
   _tprintf(TEXT("ERROR: API        = %s.\n"), pszAPI);<br />
   _tprintf(TEXT("       error code = %u.\n"), dwError);<br />
   _tprintf(TEXT("       message    = %s.\n"), szMessageBuffer);<br />
<br />
   ExitProcess(dwError);<br />
}<br />
<br />
void _tmain(int argc, TCHAR *argv[])<br />
{<br />
   BOOL                 bDaclPresent   = FALSE;<br />
   BOOL                 bDaclDefaulted = FALSE;<br />
   DWORD                dwError        = 0;<br />
   DWORD                dwSize         = 0;<br />
   EXPLICIT_ACCESS      ea;<br />
   PACL                 pacl           = NULL;<br />
   PACL                 pNewAcl        = NULL;<br />
   SC_HANDLE            schManager     = NULL;<br />
   SC_HANDLE            schService     = NULL;<br />
   SECURITY_DESCRIPTOR  sd;<br />
<br />
   // If you do not allocate some memory for psd before calling QueryServiceObjectSecurity(), you<br />
   // will get a runtime error that you are using an uninitialized pointer.  If you set it to NULL<br />
   // instead, QueryServiceObjectSecurity() will return a NULL pointer error.  The memory allocated<br />
   // below will be free'd once we find out from QueryServiceObjectSecurity() how much memory we need.<br />
   PSECURITY_DESCRIPTOR psd = (PSECURITY_DESCRIPTOR)malloc(10000);<br />
   BOOL bFreed = FALSE;<br />
<br />
   if (argc != 3)<br />
   {<br />
       _tprintf(TEXT("Usage: %s [service name] [non-Administrator-acct]\n"), argv[0]);<br />
       return;<br />
   }<br />
<br />
   char szService[80];<br />
   strcpy(szService, argv[1]);<br />
<br />
   // Obtain a handle to the Service Controller.<br />
   schManager = OpenSCManager(NULL, NULL, SC_MANAGER_CONNECT);<br />
   if (schManager == NULL)<br />
      DisplayError(GetLastError(), TEXT("OpenSCManager"));<br />
<br />
   // Obtain a handle to the service.<br />
   schService = OpenService(schManager, argv[1],<br />
                            READ_CONTROL | WRITE_DAC);<br />
   if (schService == NULL)<br />
      DisplayError(GetLastError(), TEXT("OpenService"));<br />
<br />
   // Get the current security descriptor.  Pass 0 in as the size so that we can get back the needed size.<br />
   if (!QueryServiceObjectSecurity(schService, DACL_SECURITY_INFORMATION, psd, 0, &dwSize))<br />
   {<br />
      if (GetLastError() == ERROR_INSUFFICIENT_BUFFER)<br />
      {<br />
		 // free the bogus memory that we allocated when psd was declared and allocate the real memory needed<br />
		 free(psd);<br />
		 bFreed = TRUE;<br />
         psd = (PSECURITY_DESCRIPTOR)HeapAlloc(GetProcessHeap(), HEAP_ZERO_MEMORY, dwSize);<br />
         if (psd == NULL)<br />
         {<br />
            DisplayError(0, TEXT("HeapAlloc"));<br />
            // note HeapAlloc does not support GetLastError()<br />
         }<br />
<br />
         if (!QueryServiceObjectSecurity(schService, DACL_SECURITY_INFORMATION, psd, dwSize, &dwSize))<br />
            DisplayError(GetLastError(), TEXT("QueryServiceObjectSecurity"));<br />
      }<br />
      else<br />
         DisplayError(GetLastError(), TEXT("QueryServiceObjectSecurity"));<br />
   }<br />
<br />
   // Get the DACL.<br />
   if (!GetSecurityDescriptorDacl(psd, &bDaclPresent, &pacl, &bDaclDefaulted))<br />
      DisplayError(GetLastError(), TEXT("GetSecurityDescriptorDacl"));<br />
<br />
   // Build the ACE, passing in the name of the account that the change  is for (argv[2])<br />
   BuildExplicitAccessWithName(&ea, argv[2], SERVICE_START | SERVICE_STOP | READ_CONTROL | DELETE,<br />
								SET_ACCESS, NO_INHERITANCE);<br />
<br />
   dwError = SetEntriesInAcl(1, &ea, pacl, &pNewAcl);<br />
   if (dwError != ERROR_SUCCESS)<br />
      DisplayError(dwError, TEXT("SetEntriesInAcl"));<br />
<br />
   // Initialize a NEW Security Descriptor.<br />
   if (!InitializeSecurityDescriptor(&sd, SECURITY_DESCRIPTOR_REVISION))<br />
      DisplayError(GetLastError(), TEXT("InitializeSecurityDescriptor"));<br />
<br />
   // Set the new DACL in the Security Descriptor.<br />
   if (!SetSecurityDescriptorDacl(&sd, TRUE, pNewAcl, FALSE))<br />
      DisplayError(GetLastError(), TEXT("SetSecurityDescriptorDacl"));<br />
<br />
   // Set the new DACL for the service object.<br />
   if (!SetServiceObjectSecurity(schService, DACL_SECURITY_INFORMATION, &sd))<br />
      DisplayError(GetLastError(), TEXT("SetServiceObjectSecurity"));<br />
<br />
   // Close the handles.<br />
   if (!CloseServiceHandle(schManager))<br />
      DisplayError(GetLastError(), TEXT("CloseServiceHandle"));<br />
<br />
   if (!CloseServiceHandle(schService))<br />
      DisplayError(GetLastError(), TEXT("CloseServiceHandle"));<br />
<br />
   // Free buffers.<br />
   LocalFree((HLOCAL)pNewAcl);<br />
   if (bFreed)<br />
	   HeapFree(GetProcessHeap(), 0, (LPVOID)psd);<br />
   else<br />
	   free(psd);<br />
}<br />

Rendili wrote:

Do you know if running as system would be able to access service information?

Mehmet Fatih Akbulut wrote:

this: c = new OleDbCommand("Create Table textbox1.Text ( name char(10), surname char(10), age integer , phone char(12), email char(20))",s);
or this : c = new OleDbCommand("Create Table {0} ( name char(10), surname char(10), age integer , phone char(12), email char(20))",s,textbox1.Text);

rockxuyenmandem wrote:

I haven't found any ways to do this exercise

rockxuyenmandem wrote:

am begener and live in the country that IT is weak

rockxuyenmandem wrote:

My experience in C# is not really good.

rockxuyenmandem wrote:

If you have time, plz help me.