Success!:

It seems to have been the TrustWorthy attribute on the DB

it was ON on DEV and OFF on QA and PROD

list out the trustworthyness for each db

SELECT...

To reiterate the desired results.

any user who has access to  the application and access to the window that lists out the users of the app, should see an icon next...

UPDATE: so with the proc working on DEV and passing QA testing(not against the QA server)  it was deployed to PROD on Saturday.

Whilst the proc is not bombing, the expected...

found the issue...I had a couple of IMPERSONATE grants to this user as well as from this user

found these two statements elsewhere

select *

from sys.database_permissions

where grantor_principal_id = user_id ('newuser');

SELECT

N'REVOKE '

+ permission_name...

I'll try the backup to a local drive to the server and then CREATE from file from that same local drive ...in a bit

I was able do create the cert in the master DB,

the backup of cert to file didn't yell at me

1. Log in with an account in the sysadmin role
2. Create...

hey guys didn't want to leave you hanging, but Jeff's suggestion was the easiest fix.

In the query window, signed on as user A, running the proc it showed the users...