Home Forums SQL Server 2008 Security (SS2K8) Permissions to access all sysusers records RE: Permissions to access all sysusers records

  • March 8, 2017 at 6:09 am

    #1932267

    John Mitchell-245523 - Wednesday, March 8, 2017 5:42 AM

    This is going to fail if the user who created the record has since been deleted.  Why don't you change the function so it gets the user name instead of the ID, and then you wouldn't need to join to a system view at all?

    John

    I don't delete the users. They just get disabled when they leave the company.

    I might have to go this route but this is going to be a lot of work and storing names (VARCHAR) vs IDs (INT) is kind of against the 'SQL nature'

    ---------------------------------------------
    [font="Verdana"]Nothing is impossible.
    It is just a matter of time and money.[/font]