exec master..dbd_set_session_profile @profile sysname

Activates a profile only for the current session. The profile must already exists. If the session disconnected and connected again, the profile is unset.

When the profile is set for a specific login or temporary, it can't be deleted. It must be previously unset. A temporary profile is implicitly unset when session is terminated.

Related functions

master..dbd_create_profile - Creates and stores a profile

master..dbd_list_profiles - Lists profiles

master..dbd_set_profile - Sets (activates) or unsets (deactivates) a profile

master..dbd_del_profile - Deletes a profile