User got created with first letter capitalized

From: John Scalia <jayknowsunix(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: User got created with first letter capitalized
Date: 2016-07-25 15:51:58
Message-ID: CABzCKRBh9GW4zWKTa_X4a+8h7A=GjHRe-CO43y-aonJg30fyHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a user who was inserted into the db by one of our automation
scripts. His ID has the very first letter capitalized. The script reads
the users from the appropriate Active Directory group and makes sure they
exist in the database.

For grins, let's say the user is good old Charley Brown and is called
"Cbrown1" in Active Directory. If I look for him by rolname in either
pg_authid or the pg_roles view, He shows as:

rolname
-----------
Cbrown1
(1 row)

but when I try then to get rid of him using either "DROP ROLE cbrown1;" or
"DROP ROLE Cbrown1;" I receive "ERROR: role "cbrown1" does not exist. Note
that I get the error with the name in all lower case regardless of which
way I specify him.

Also, he does not show up using \du Cbrown1 or \du+ cbrown1, but does show
if I enter \du without specifying his id.

Anyone know what's going on with this?
--
Jay

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2016-07-25 15:56:36 Re: User got created with first letter capitalized
Previous Message Gupta, Amar Nath 2016-07-25 07:51:18 Re: High-end PG database configuration help