Checking SQL Serever 2005 Machine's local policy.

I have created a user for a SQL 2005 server and I am supposed to check to make sure that the user has the following permissions.
- Act as part of the operating system
- Adjust memory quotas for a process
- Log on as a batch job
- Log on as a service
- Replace a process level token

My question is how do I check the SQL server machines local security policy for these permissions?

Thank you


Richard ComitoDirector of ITAsked:
Who is Participating?
 
BrughConnect With a Mentor Commented:
Sorry, you said local.. my bad.

Try going into Administrative Tools->Local Secruity Policy and make the changes there.  :)

 - Brugh
0
 
BrughCommented:
Start-> run
Type gpedit.msc
Expand down to
Windows Settings->Security Settings->Local Policies->User Rights Assignments.
Find the "rule" that you want to configure. Double Click on it and modify accordingly.

In reality, as long as the user is part of the Administrators group, you should be fine.

 - Brugh

0
 
Richard ComitoDirector of ITAuthor Commented:
Brugh,

Thanks for the reply.  The user is part of the administrator group and the group is part of all the policies except log on as a service.  This one only has one user added and it is domain\besAdmin and the add group button is grayed out.

Gabicus
0
 
Richard ComitoDirector of ITAuthor Commented:
Brugh,

Thanks for the info.  That did help in trouble shooting the issue that I am having.

Gabicus
0
All Courses

From novice to tech pro — start learning today.