QOD Today

Question

QOD Today

Wenck

SSC Enthusiast

Points: 188
More actions
June 17, 2003 at 9:18 pm

#357804

Well I just got an email and it's pretty useless trying to answer it in the email and then click Answer.
That sends me to a page which says "An error has occured where we can't find the question you wish to answer. Please press back and try again. You may have to go to the newsletter and click Answer again. You can also go to http://www.sqlservercentral.com/testcenter/QOD.asp to resubmit the answer."
When I click on the link, that takes me to all the questions, except today's question isn't listed. ie. Mary and Accounting.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Brian Knight One Orange Chip Points: 27249 More actions · Answer 1

That generally means that the email client didn't pass your user name to the form. The QOD should be posted now. It posts daily at 2am EST.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Brian Knight
Free SQL Server Training Webinars

fhtapia SSC Eights! Points: 994 More actions · Answer 2

No problems here, I am using OE tho.

-Francisco

cholliet SSC Veteran Points: 266 More actions · Answer 3

Granted, revoked, denied. Semantics, purely semantics. Why can't engineers, programmers, application designers, system administrators or any other technologists use the language in a way that makes the technology easier to understand? Why does it always seem like so many word games for the purpose of general confusion?

wmp789 SSCarpal Tunnel Points: 4354 More actions · Answer 4

I got the same error msg. Click the link provided, you should be able to answer from there.

http://www.sqlservercentral.com/testcenter/QOD.asp

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 5

quote:
Granted, revoked, denied. Semantics, purely semantics. Why can't engineers, programmers, application designers, system administrators or any other technologists use the language in a way that makes the technology easier to understand? Why does it always seem like so many word games for the purpose of general confusion?

You have different people designing different systems. How them use the nomenclature is going to be based on their experience and their jargon. Language is always going to be an issue. For instance:

"I've got to go TDY to 7-level school for my AFSC at Keesler. Hopefully I'll do well enough to be DG."

If I carried that conversation with another US Air Force person, they'd understand in a second what I was saying. If I stepped across and carried that same conversation with say a member of the Marine Corps, they'd understand TDY and Keesler, but they might not understand 7-level school, AFSC, or DG. Now, if I had that same conversation with someone who hadn't ever been in the military, they probably wouldn't understand anything I just said except maybe Keesler. We all use jargon, whether or not we realize it or not.

Another example:

"The developer had dbo rights and managed to drop the tables. Get with the sysadmin to pull the backup tape for the server. We need to grab the full and the differential and perform a restore back to 2 days ago. You're going to need to send out an email to all the developers telling them to stay out of the db because we'll have to put it in single-user mode until we're done."

To the DBA, that should all make sense. But even to a system administrator, some of that may be incomprehensible. Now, imagine you were Joe Blow on the streets. Talk about dropping tables probably has a totally different connotation than for the DBA.

But it all boils down to this:

GRANT = I give you permissions.

DENY = I explicitly deny you permissions.

REVOKE = I undo any grant or deny I may have previously issued.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

Hi cholliet

quote:
Granted, revoked, denied. Semantics, purely semantics. Why can't engineers, programmers, application designers, system administrators or any other technologists use the language in a way that makes the technology easier to understand? Why does it always seem like so many word games for the purpose of general confusion?

I don't think that general confusion is the intention. The language is somewhat straight forward.

But when it comes to testings the wording is an integral part of any test, just to see how the candidate reacts on, especially when the time component is involved.

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

ge_anand SSC Enthusiast Points: 171 More actions · Answer 7

Hi,

I believe that the correct answer to todays question is incomplete.

Simply executing the SQL statements alone will not set C2-Level audit security, but, the server needs to be restarted, for the values to be reflected in the present running instance.

I welcome your comments on this.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 8

Hi ge_anand,

quote:
I believe that the correct answer to todays question is incomplete.
Simply executing the SQL statements alone will not set C2-Level audit security, but, the server needs to be restarted, for the values to be reflected in the present running instance.

maybe incomplete, but good enough to answer the question

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

ChrisMoix SSCommitted Points: 1568 More actions · Answer 9

Don't you need to set allow updates to system tables on before changing to C2 security? IE:

USE master

EXEC sp_configure 'allow updates', '1'

RECONFIGURE

And then for good measure, turn it back off again?