Security Principals

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Security Principals

Security Principals

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Saturday, September 20, 2008 10:14 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

Comments posted to this topic are about the item Security Principals

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #573095

bitbucket-25253

Posted Sunday, September 21, 2008 8:55 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 5,099, Visits: 20,191

Great question ..Now for a trival comment the link shown for the correct answer

http://msdn.microsoft.com/en-us/library/ms187929.aspx

Displays a MSDN page titled Using SQL Server Profiler:

However this link http://msdn.microsoft.com/en-us/library/ms188786.aspx yields sys.server_prinicipals(Transact-SQL) produces from BOL for SQL Server 2008

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #573138

Steve Jones - SSC Editor

Posted Monday, September 22, 2008 7:15 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

Thanks, fixed.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #573470

Mohamed-401375

Posted Monday, September 22, 2008 12:45 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, November 26, 2012 5:36 PM
Points: 869, Visits: 96

Good question.

I guess this article relates more to the question than the one posted.

http://msdn.microsoft.com/en-us/library/ms181127.aspx

Post #573777

Anipaul

Posted Tuesday, September 23, 2008 9:00 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:50 AM
Points: 4,785, Visits: 1,334

Nice question....

Post #574479

L' Eomot Inversé

Posted Saturday, October 02, 2010 9:22 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:59 AM
Points: 7,076, Visits: 7,115

Good question.

I was in two minds whether to tick "certificates" or not: after all, Server Level principals like ##MS_PolicySigningCertificate##, ##MS_PolicyEventProcessingLogin##, and so on are certificate derived, some even include "Certificate" in their names, and given the general standard of questions I thought that there was an even chance that the question setter didn't distinguish these principals from the certificates from which they are derived. So I flipped a mental coin and came up with the wrong answer. If I'd known Steve had set the question I would have chosen differently. Wink

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #997222

« Prev Topic | Next Topic »

Permissions