Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

In sysusers table - Onle column is isaliased - Can you please tell me what is it meaning Expand / Collapse
Author
Message
Posted Saturday, March 8, 2014 12:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 11:20 AM
Points: 67, Visits: 242
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.
Post #1548983
Posted Saturday, April 26, 2014 9:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:57 AM
Points: 1,294, Visits: 3,725
I believe you will find the answer here


Note that sysusers is depreciated, use sys.database_principals instead.
Post #1565332
Posted Saturday, April 26, 2014 10:35 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 3,354, Visits: 7,254
Maybe a free reference would be better.
http://www.mssqltips.com/sqlservertip/1675/security-issues-when-using-aliased-users-in-sql-server/



Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1565336
Posted Saturday, April 26, 2014 10:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:57 AM
Points: 1,294, Visits: 3,725

Ooops sorry about that
and thanks Luis!
Post #1565337
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse