valid_user

Description

Returns 1 if the specified ID is a valid user or alias in at least one database on this Adaptive Server.

Syntax

valid_user(server_user_id)

Parameters

server_user_id

is a server user ID. Server user IDs are stored in the suid column of syslogins.

Examples

Example 1

select valid_user(4)
---------------
              1

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

You must be a System Administrator or a System Security Officer to use this function on a server_user_id other than your own.

See also

System procedures sp_addlogin, sp_adduser