In Win32, call GetTokenInformation, passing a token handle and the TokenUser constant. It will fill in a TOKEN_USER structure for you. One of the elements in there is the user’s SID. It’s a BLOB (binary), but you can turn it into a string by using ConvertSidToStringSid. To get hold of the current token handle, use … Read more
The podcast tells me I should ask, and answer, questions when they’re not answered on SO already. Here goes. The easy way, with .NET 2.0 and up, is this: NTAccount f = new NTAccount(“username”); SecurityIdentifier s = (SecurityIdentifier) f.Translate(typeof(SecurityIdentifier)); String sidString = s.ToString(); The hard way, which works when that won’t, and works on .NET … Read more
See here for a good answer: The best way to resolve display username by SID? The gist of it is this bit: string sid=”S-1-5-21-789336058-507921405-854245398-9938″; string account = new System.Security.Principal.SecurityIdentifier(sid).Translate(typeof(System.Security.Principal.NTAccount)).ToString(); This approach works for me for non-local SID’s over the active directory.
Quote by @DAC In short: SID = the unique name of your DB, ServiceName = the alias used when connecting Not strictly true. SID = unique name of the INSTANCE (eg the oracle process running on the machine). Oracle considers the “Database” to be the files. Service Name = alias to an INSTANCE (or many … Read more