Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    13

    Unanswered: How to check if there's any alias of DB user?

    Dear all

    How to check if there's any alias of DB user?
    E.g.
    I've run sp_addalias user1, dbo

    but, how to check user1 is an alias of dbo ?

    Thanks&Regards

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    If you use "sp_helpuser dbo" it will show you the list of aliases. For example:

    Code:
    1> sp_helpuser dbo;
     Users_name ID_in_db    Group_name Login_name
     ---------- ----------- ---------- ----------
     dbo                  1 public     sa
    Users aliased to user.
    
     Login_name
     ----------
     michael
    
    (return status = 0)
    The actual information is stored in the sysalternates table.

    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •