All geek questions in one place

Enable sys, guest, and information_schema users in SQL Server

I had a script working with one of my databases that was trying to reset a bunch of users. All users who had an attempt to iterate were disconnected and displayed a small red down arrow on their icon in Management Studio.

I was able to revive all ordinary users by issuing the "change myLogin login" command. However, when I try to do this against sys, guest or information_schema users, I get "Can't change myLogin login" because it does not exist or you do not have permission. I am registered as a system administrator.

How to enable these accounts?

+3
source share
2 answers

, , "" " ", " SQL Server" , , ALTER LOGIN.

, , , , CONNECT, . , :

   GRANT CONNECT TO guest

REVOKED :

REVOKE CONNECT FROM guest
+5

Management Studio, , , - , [ServerName] → [DatabaseName] → Security → Users ( ), ( , "", ).

, [ServerName] → Security → Logins. , " " . , , . "", .

+1

Source: https://habr.com/ru/post/1717165/

More articles:


All Articles