lundi 20 avril 2015

Current role name in prompt

I add to my PROMPT1 and PROMPT2 the %n parameter to show the current user. I thought that it works like SELECT CURRENT_USER; but when I changed my role with SET ROLE role_name; I noticed that user in my prompt doesn't changed but in CURRENT_USER is role name as I expected.

Is there any way to display in prompt the current role instead of current user?

Aucun commentaire:

Enregistrer un commentaire