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: Friday, August 29, 2014 8:31 AM
Points: 72, Visits: 256
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:26 AM
Points: 1,768, Visits: 4,626
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: Yesterday @ 3:08 PM
Points: 3,545, Visits: 7,659
Maybe a free reference would be better.
http://www.mssqltips.com/sqlservertip/1675/security-issues-when-using-aliased-users-in-sql-server/



Luis C.
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?

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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:26 AM
Points: 1,768, Visits: 4,626

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

Add to briefcase

Permissions Expand / Collapse