How to check certain attributes for a USER in SQL Server

Asked Jun 15 '16 at 10:43

Active Jun 15 '16 at 11:05

Viewed 80 times

I am trying to find the table in which I can check if a user is enabled or disabled. For example if I were to execute this command

use Database
Go
Revoke Connect from "DomainName\abcdef"

The changes are probably reflected in one of the tables, I would like to know which one. I AM NOT interested in the change in the GUI (i.e SSMS)

Also I would like to know whether the User Login Policies are enforced or not, by knowing which table these attributes are in.

I have successfully found the table for a Login(server) i.e.

sys.sql_logins

I need to find it for a USER of a single database.

edited Jun 15 '16 at 11:05

marc_s

asked Jun 15 '16 at 10:43

XChikuX

Looked at `sys.sysusers`? – Chris Pickford Jun 15 '16 at 11:01
There's an excellent answer here http://stackoverflow.com/questions/7048839/sql-server-query-to-find-all-permissions-access-for-all-users-in-a-database – Rich Benner Jun 15 '16 at 11:03

0 Answers0