Viewing 15 posts - 31 through 45 (of 65 total)
Hmm. Interesting.
When I read up on about alerts, it sounded like one of use cases was to be more proactive when the database starts to push the server (and...
February 15, 2012 at 10:44 am
Bumping in hopes that a kind soul may know about such list available or at least a good article that'll help with figuring out what alerts may be appropriate for...
February 15, 2012 at 9:26 am
Dev, that much is clear, yes but securityadmin can grant CONTROL SERVER to other logins. While CONTROL SERVER isn't same as being a sysadmin, that's just too much for my...
November 30, 2011 at 4:57 am
Thanks usman & sujeet for the link to the article. The idea of using DDL trigger to block the CONTROL SERVER grant sounds like a good idea if I can't...
November 30, 2011 at 4:52 am
Usman, correct. That's what I was really hoping to not have to do.
At least the certificate login cannot be impersonated, and signing any sprocs requires CONTROL permission on the...
November 30, 2011 at 4:25 am
Divine Flame (11/29/2011)
I hope you are clear now that why CONTROL SERVER permission was required.;-).
Uh, no. CONTROL SERVER was never ever needed for what I needed to do with the...
November 30, 2011 at 3:44 am
Dev (11/29/2011)
That's the beauty of MSDN articles. They are well organized. :hehe:
I'm appreciating this now! I'm in an odd position because I'm doing my darnedest to soak up...
November 29, 2011 at 6:44 am
Divine Flame (11/29/2011)
Did you find your explanation/solution ?
See Dev's post. I think that's the answer.
Dev (11/29/2011)
Verify Permissions section...
Gotcha. The page I linked was for server permissions (my OP...
November 29, 2011 at 5:51 am
Dev (11/29/2011)
If Database user mapped to a certificate, Membership in the db_securityadmin fixed database role, membership in the db_owner fixed database role, or membership in the sysadmin fixed...
November 29, 2011 at 5:34 am
Ah, I see what you're going at. My apologies for not being clear but in this case, I'm thinking more about the timestamps of the record than for debugging purposes....
November 28, 2011 at 11:21 am
Right, and I can see that as OK with a web application or middle-tier application where source code executable is more likely to be inaccessible but I have to admit...
November 28, 2011 at 7:38 am
I want to revisit the subject with a bit different take.
1) Would the architecture make any difference in whether the users' going to be in a user defined table or...
November 27, 2011 at 8:21 am
Do you happen to have any documentation suggesting this?
From this page, the securityadmin fixed role does not have CONTROL SERVER and ALTER ANY LOGINS is the only permission granted to...
November 25, 2011 at 10:17 am
Well, I didn't explicitly test this but I assumed not so because is_disabled correlate to whether a login is disabled or not and not to whether a login is locked...
November 23, 2011 at 4:21 pm
It's the same article I linked to in my OP. As explained to Jeff, I got fixated on the wrong section.
Here's the link again: Erland's treatise.
More specifically this part:
and...
November 8, 2011 at 3:14 pm
Viewing 15 posts - 31 through 45 (of 65 total)