Post reply

Getting login Type

  • December 23, 2003 at 2:01 pm

    #160439

    Hi,

    Does anyone know how to obtain an account’s Type that is shown in Enterprise Manager, Server, Security, Logins? I need to know if an account is Standard, Windows Group, or Windows User. I would like to be able to do this in a query. Any help is greatly appreciated.

    Thanks

  • December 23, 2003 at 2:25 pm

    #487682

    You want to look at the isntuser and isntgroup columns of syslogins.

  • December 23, 2003 at 2:25 pm

    #487681

    You want to look at the isntuser and isntgroup columns of syslogins.

  • December 26, 2003 at 8:12 am

    #487823

    I guess I'm blind, but what database is syslogins in?

  • December 26, 2003 at 8:23 am

    #487824

    never mind, I found it. Doesn't show in EM!!! I thought this was the table I needed, but just couldn't see it.

    Thanks All!

  • December 26, 2003 at 11:39 am

    #487834

    Lee,

    syslogins is not a table, its a view, which is probably why you couldn't find it in EM.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply