ok so my DB is now working as far as authenticating windows creds against the roles is concerned - question - how can i extract the account entered? coz i want to log whoever uses the DB.
This will probably help you. Powershell Universal creates variables depending on what is being accessed. In your case, $User is what you are looking for.
that did it - thanks!