sys.sp_helpuser

Description

Reports information about database-level principals in the current database.

Syntax

sp_helpuser [ [ @name_in_db = ]
N
'name_in_db'
]
[ ; ]

Examples

Example 1

sp_helpuser

Example 2

sp_dropuser

Example 3

INFORMATION_SCHEMA

Example 4

master

Example 5

tempdb

Example 6

EXECUTE sp_dropuser 'guest'

Example 7

CONNECT

Example 8

sp_dropuser

Example 9

ALTER ANY USER

Example 10

Albert

(. and 1 more examples)