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

denylogin & hasaccess of syslogins Expand / Collapse
Author
Message
Posted Thursday, January 30, 2014 4:28 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 5:28 AM
Points: 67, Visits: 180
Dear All,

Login ENABLE or DISABLE is made any change in sys.syslogins tables.

Please clarify.
Post #1536247
Posted Thursday, January 30, 2014 5:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 41,529, Visits: 34,445
syslogins is an old SQL 2000 compatibility view. Since you couldn't disable logins in SQL 2000, the view won't show the disabled property. Use sys.server_principals, which is the current view that displays logins, and you'll see a column called is_disabled.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1536257
Posted Thursday, January 30, 2014 10:05 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 5:28 AM
Points: 67, Visits: 180
Thank you Sir,

Please clarify what is difference between Permission to connect to database engine and Login in the Login Properties windows ?
Post #1536629
Posted Sunday, February 02, 2014 8:45 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:16 AM
Points: 153, Visits: 945
Maybe you want to check BOL
http://technet.microsoft.com/en-us/library/ms180015%28v=sql.105%29.aspx


Andreas

---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
Post #1537140
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse