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 12»»

Database Roles Expand / Collapse
Author
Message
Posted Sunday, February 22, 2009 12:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:36 PM
Points: 5,601, Visits: 25,005
Comments posted to this topic are about the item Database Roles

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 #662146
Posted Sunday, February 22, 2009 4:41 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, March 30, 2014 8:18 PM
Points: 2,778, Visits: 477
There is a db_sysltduser role in the msdb database, but not db_sysitduser role, looks like a uppercase 'I' was mistaken for a lower case 'l' in the role name!


Post #662298
Posted Monday, February 23, 2009 2:26 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 5:16 AM
Points: 2,459, Visits: 306
There is no DB_SSISITDUSER but only a DB_SSISLTDUSER (when uppercased).

Seems this question has a fault in it.



Post #662426
Posted Monday, February 23, 2009 3:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 4:05 PM
Points: 1,033, Visits: 140
There is definitely no db_ssisitduser, and therefore this option is incorrect, not just a misspelled character. The QoD should teach the participants to carefully read the question and answer to what was asked, without having to assume what the writer might have had in mind. In real world, a script with "db_ssisitduser" would fail the same way as with "dc_user".
Post #662436
Posted Monday, February 23, 2009 3:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, February 28, 2014 4:04 AM
Points: 1,052, Visits: 109
Hi, I've noticed that db_ssisitduser is being classed as a correct answer where SQL BOL 2008 states there is no such user, I'm guessing there's a typo here and the option should have read db_ssisltduser.

I did think about checking the forum before I answered this question as I thought it might have been a mistake, but then I thought I'd be cheating myself an extra point! ;)




Post #662440
Posted Monday, February 23, 2009 5:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, February 14, 2013 7:48 AM
Points: 2,647, Visits: 135
At first I chose the db_ssisitduser, but then realized it's actually db_ssisLtduser. A very confusing typo!
Post #662490
Posted Monday, February 23, 2009 6:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 18, 2012 12:29 PM
Points: 1,078, Visits: 109
just adding to agree with the other comments re: db_ssisitduser
vs. db_ssisltduser
Post #662506
Posted Monday, February 23, 2009 6:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:13 AM
Points: 2,878, Visits: 468
I agree with the others, there is db_ssisltduser but no db_ssitduser.


Post #662517
Posted Monday, February 23, 2009 6:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:04 PM
Points: 6,594, Visits: 8,882
I also fell into the typo trap. So I post to get my point anyway...

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #662519
Posted Monday, February 23, 2009 7:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 10, 2014 10:06 PM
Points: 65, Visits: 70
Just making sure I'm not the only one who missed this because of the typo. boo

Technical conquests for the nerd in all of us
www.tavislovell.com
Post #662538
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse