In sysusers table - Onle column is isaliased - Can you please tell me what is it meaning

• rajeshjaiswalraj

  SSCrazy

  Points: 2574

  More actions

  March 8, 2014 at 12:00 pm

  #98963

  I have checked sysusers table in sql server 2008.

  There is one column name called isaliased - If it is 1 = Account is aliased to another user.

  But I m not getting account is aliased to other user meanin.

  Please help and explain me any one.

• Eirikur Eiriksson

  SSC Guru

  Points: 182882

  More actions

  April 26, 2014 at 9:37 am

  #1708971

  I believe you will find the answer here

  😎

  Note that sysusers is depreciated, use sys.database_principals instead.

• Luis Cazares

  SSC Guru

  Points: 183698

  More actions

  April 26, 2014 at 10:35 am

  #1708974

  Maybe a free reference would be better. 😉

  http://www.mssqltips.com/sqlservertip/1675/security-issues-when-using-aliased-users-in-sql-server/

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Eirikur Eiriksson

  SSC Guru

  Points: 182882

  More actions

  April 26, 2014 at 10:38 am

  #1708975

  Luis Cazares (4/26/2014)

  ---

  Maybe a free reference would be better. 😉

  http://www.mssqltips.com/sqlservertip/1675/security-issues-when-using-aliased-users-in-sql-server/

  Ooops:ermm: sorry about that

  and thanks Luis!

  😎