Database permissions

Question

Database permissions

SQLDCH

SSChampion

Points: 11601
More actions
October 2, 2013 at 11:56 pm

#299315

Comments posted to this topic are about the item Database permissions
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
Yeah, well...The Dude abides.
October 3, 2013 at 5:33 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 24 total)

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

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

Nice one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 2

Not a big fan of questions involving deprecated features, that never seem to go away.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Carlo Romagnano SSC-Insane Points: 22596 More actions · Answer 3

Ford Fairlane (10/3/2013)
Not a big fan of questions involving deprecated features, that never seem to go away.

+1

SQLDoubleG Hall of Fame Points: 3100 More actions · Answer 4

SQLDoubleG

Hall of Fame

Points: 3100

October 3, 2013 at 1:46 am

#1655426

Nice and easy, thanks for the question!

Toreador SSChampion Points: 11358 More actions · Answer 5

Putting this in the category "ALTER ROLE" was a bit of a giveaway!

TomThomson SSC Guru Points: 104773 More actions · Answer 6

Nice question.

I find it quite surprising that 58% of answers so far were wrong; and even more surprising that nearly half of the wrong answers were not sp_addrolemember but one of the other two options.

Tom

Dscheypie SSCommitted Points: 1545 More actions · Answer 7

L' Eomot Inversé (10/3/2013)
Nice question.
I find it quite surprising that 58% of answers so far were wrong; and even more surprising that nearly half of the wrong answers were not sp_addrolemember but one of the other two options.

This has the characteristics of wild guesses 🙂 Apparently people didn't work with this using T-SQL.

For me it is interesting to see that till version 10.5 you could only rename a role by using the ALTER ROLE statement.

Only beginning with 11 you can also ADD or DROP database principals. Just tried it out on 9.0 and 10.0.

________________________________________________________
If you set out to do something, something else must be done first.

Tee Time Hall of Fame Points: 3745 More actions · Answer 8

Tee Time

Hall of Fame

Points: 3745

October 3, 2013 at 6:26 am

#1655529

Good one, thanks!

Thomas Abraham SSChampion Points: 10761 More actions · Answer 9

Toreador (10/3/2013)
Putting this in the category "ALTER ROLE" was a bit of a giveaway!

Plus, now we have to deal with category inflation! 😉 When you click on the category, you find that this is the only question in the category.

This reminds me of the wrestle I have with my coworkers over keeping shared file directories tidy. There is a frequent tendency to keep adding new directories, or even worse, dropping files in the top-level directory. They don't see how this clutter makes it hard to find stuff. When I mention that that could make a cursory scan of the existing files and see if one is appropriate, they respond that they can always do a "search" in Explorer to find it. (However, since they use the same random number generator to create file names, they can't find their own files by name!) Kind of like excusing yourself from adding an index to a table, because you know you can always do a table scan. Ugh!

(BTW, I note that there are currently question categories for "Log Shipping" and "LogShipping". :w00t:)

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

paul s-306273 SSChampion Points: 10727 More actions · Answer 10

Well, the category was 'ALTER ROLE'.

Bit of a give away...

Dana Medley SSCertifiable Points: 6764 More actions · Answer 11

Dana Medley

SSCertifiable

Points: 6764

October 3, 2013 at 7:50 am

#1655562

Good question, thanks.

Everything is awesome!

SQLDCH SSChampion Points: 11601 More actions · Answer 12

L' Eomot Inversé (10/3/2013)
Nice question.
I find it quite surprising that 58% of answers so far were wrong; and even more surprising that nearly half of the wrong answers were not sp_addrolemember but one of the other two options.

I threw out a red herring with the Oracle syntax (GRANT <database role> to <database user>), could account for some of those numbers 🙂

----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------

Yeah, well...The Dude abides.

TomThomson SSC Guru Points: 104773 More actions · Answer 13

SQLDCH (10/3/2013)
L' Eomot Inversé (10/3/2013)
Nice question.
I find it quite surprising that 58% of answers so far were wrong; and even more surprising that nearly half of the wrong answers were not sp_addrolemember but one of the other two options.
I threw out a red herring with the Oracle syntax (GRANT <database role> to <database user>), could account for some of those numbers 🙂

Ah, that was a clever move, and might well account for more than half of them (60% of the wrong answers that were not the deprecated sp were that one). I like that sort of red herring. Maybe I should have noticed it, but I didn't - I've forgotten all I used to know about Oracle (except that it's both very expensive and rather difficult to manage).

Tom