Admin/Admin Privileges in Win 8.1

  • Thread starter Thread starter WWGD
  • Start date Start date
Click For Summary

Discussion Overview

The discussion revolves around the nature of administrative privileges on a Windows 8.1 computer that is not password-protected. Participants explore the implications of this setup, including whether the original owner's lack of security measures affects the current user's administrative capabilities and the relationship between local and SQL Server administration.

Discussion Character

  • Exploratory
  • Debate/contested
  • Technical explanation

Main Points Raised

  • Some participants suggest that the user can make themselves an admin due to the lack of password protection on the computer.
  • Others express concern about the security implications of such a setup, questioning whether Windows security is too lax.
  • A participant notes that if the original owner set up the account without restrictions, anyone using the computer effectively operates as that user.
  • One participant mentions that while they have admin-like powers, they encounter limitations when using SQL Server, indicating a distinction between local admin rights and database access rights.
  • There is a clarification that being a local Windows admin does not automatically confer admin status in SQL Server, as permissions are managed separately.
  • Participants discuss the importance of following security protocols and the challenges in enforcing them.

Areas of Agreement / Disagreement

There is no consensus on whether the user is formally an admin or the implications of that status in relation to SQL Server. Multiple competing views exist regarding the security of Windows and the nature of administrative privileges.

Contextual Notes

Participants highlight the distinction between local administrative rights and permissions required for accessing network resources or specific applications like SQL Server. There are unresolved questions about the exact nature of the user's administrative status and the limitations they face.

Who May Find This Useful

This discussion may be useful for users navigating administrative privileges on Windows systems, particularly in contexts involving SQL Server and security settings.

WWGD
Science Advisor
Homework Helper
Messages
7,795
Reaction score
13,095
Hi All,
My brother just gave me his old computer, of which he was the admin.
The computer is not password-protected, i.e., I do not have to login into it
to use it. I guess strictly-speaking, I am not the admin, as the computer name
is under his name. Still, given the computer is not password-protected, is there
any restriction on what I ( or anyone) can do in the computer? Would I have to
reset the computer to factory state in order to become the admin myself?
 
Computer science news on Phys.org
Make yourself an admin.
 
Noisy Rhysling said:
Make yourself an admin.
Is Windows security that lax that anyone can just go on and make themselves admin? I thought there would be serious obstacles to allowing that, given once you're admin, you can do/access anything you want.
 
Noisy Rhysling said:
Make yourself an admin.
You already are...
WWGD said:
My brother just gave me his old computer, of which he was the admin.
I do not have to login into it to use it.
You are your brother when you use it... lol

WWGD said:
Is Windows security that lax that anyone can just go on and make themselves admin?
If your brother set up his account that way, everyone that uses the computer is your brother... the administrator.

Admin.JPG


My first name really is Paul, and if my wife uses this computer... it thinks she is me... :DDFor security purposes, you really shouldn't run all the time as the admin, though... I have a non-admin account that I use most of the time.I might be wrong about some of this stuff, too... :blushing:
 

Attachments

  • Admin.JPG
    Admin.JPG
    15.8 KB · Views: 496
WWGD said:
Is Windows security that lax that anyone can just go on and make themselves admin? I thought there would be serious obstacles to allowing that, given once you're admin, you can do/access anything you want.
If the computer is not password protected all the security features are useless.
 

Attachments

  • Major Tom.JPG
    Major Tom.JPG
    26 KB · Views: 484
WWGD said:
Is Windows security that lax that anyone can just go on and make themselves admin?
No, it is not lax, it just allows YOU to decide, when you buy and set up a computer, whether or not you want security. If you want it to be lax (and your brother did) you have that option --- that is your/his choice, not Microsoft's.
 
  • Like
Likes   Reactions: Tom.G
Ok, thanks all, my bad, I violated the 90-10 rule: 90% of the difficulty in enforcing security is having people follow rules , 10% is setting them up, doing the technical work. Still, not sure I understood, am I formally the admin? I know I have admin-like powers, but I am getting messages when using SQL Server not allowing me to do certain things, on the grounds that I am not the admin. I am signing in using Windows Authentication, which would most often imply I am the admin, but SQL Server suggests I am not.
 
Check if you can create a file in C:\Windows.
Only admins can (of Windows on the local system).
 
  • Like
Likes   Reactions: WWGD
  • #10
upload_2017-10-22_14-30-15.png


and then "change your account type" and it will tell you if you are an admin and if you are not, it will let you become one (or set up a new account that IS an admin, which really is better so that you can run normally as NOT an admin)
 

Attachments

  • upload_2017-10-22_14-30-15.png
    upload_2017-10-22_14-30-15.png
    9.5 KB · Views: 1,064
  • Like
Likes   Reactions: WWGD
  • #11
phinds said:
Ah, the trick of looking it up , my bad, I just though I could avoid having to filter thru the nonsense one gets when searching, thanks.
 
  • #12
For the record, there's a difference between being a local Windows admin, and being an admin when accessing a network or dedicated database program.
 
  • Like
Likes   Reactions: WWGD
  • #13
I like Serena said:
For the record, there's a difference between being a local Windows admin, and being an admin when accessing a network or dedicated database program.
Thanks, but if you are the windows admin, don't you become (an) admin in SQL Server , by using Windows authentication? EDIT: Though I don't think the converse is true.
 
  • #14
WWGD said:
Thanks, but if you are the windows admin, don't you become (an) admin in SQL Server , by using Windows authentication? EDIT: Though I don't think the converse is true.
'Windows Authentication' is the term used when accessing network resources.
It is separate from just logging in locally on a Windows computer, although Microsoft has integrated the two somewhat.

Locally you log in with either a local account, or with a domain account that belongs to a larger network.
Locally on your system, both types of accounts can be added to the Administrators group, meaning you can manage your local system completely.
For access to remote resources, your permissions are managed remotely by a network administrator.
I'm not familiar with SQLServer, but I expect it has its own dedicated user account management. To change permissions you likely have to log into a SQLServer Admin console.

Windows does allow you through 'Integrated Windows Authentication' to identify yourself to remote resources through your local login.
But the permissions you have there are outside the control of your local system.
 
  • Like
Likes   Reactions: WWGD

Similar threads

  • · Replies 5 ·
Replies
5
Views
10K
  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 2 ·
Replies
2
Views
3K
Replies
1
Views
3K
Replies
127
Views
23K
  • · Replies 6 ·
Replies
6
Views
9K
  • · Replies 13 ·
Replies
13
Views
6K
  • · Replies 151 ·
6
Replies
151
Views
27K
  • · Replies 1 ·
Replies
1
Views
3K