Doesn't security cascade down?

Question

Doesn't security cascade down?

Viewing 7 posts - 16 through 21 (of 21 total)

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

Brandie Tarvin SSC Guru Points: 173063 More actions · Answer 1

ALZDBA (1/28/2011)
Brandie Tarvin (1/28/2011)
Maybe I'm misunderstanding you, but are you saying having multiple schemas is a bad idea? If so, I disagree with this statement. The new schema structure is much better than the old ownership structure and makes security much easier to deal with IMHO. There are a few issues (such as the use of sp_helptext) that take a bit of getting used to, but it's been a good experience over at my workplace, and very handy for segregating things properly.
No. What I wanted to state is one should by default create a schema and not create objects on the dbo schema.

Ah. Sorry. Early in morning. Apparently I can't read yet. Thank you for clarifying.

Also, thanks for the info on the bug. I never noticed it. Then again, I don't think I worked Rep in an environment that had user-owned objects.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 2

No problem. Enjoy your first coffee 😉

eeuhm ... and indeed, a deny will always overrule the others, even with the user defined db roles.

That's why ms performs role membership tests in some of its stored procedures.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

WayneS SSC Guru Points: 95460 More actions · Answer 3

Koen (da-zero) (1/27/2011)
WayneS (1/27/2011)
Which makes what I'm trying to do a PITA. 🙁
Pita?
http://upload.wikimedia.org/wikipedia/commons/5/5f/Pita_topped_with_artichoke_hummus_and_lamb.jpg

I'm not sure if I just used an acronym that you're not familiar with, or if you're being funny with me. So, PITA is Pain In The ~~A$$~~ rear

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 4

PITA

Pain in the A$$

Interesting that I first heard this from an 80 + year old uncle.

Greg E

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Greg Edwards-268690 (1/28/2011)
PITA
Pain in the A$$

Thanks for the clarification.

But my version is much tastier 🙂

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

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 6

Koen (da-zero) (1/28/2011)
Greg Edwards-268690 (1/28/2011)
PITA
Pain in the A$$
Thanks for the clarification.
But my version is much tastier 🙂

Important to understand which context PITA is being used.

In Wayne's case, it is not the yummy version.

Greg E

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Koen (da-zero) (1/27/2011)
WayneS (1/27/2011)
Which makes what I'm trying to do a PITA. 🙁
Pita?
http://upload.wikimedia.org/wikipedia/commons/5/5f/Pita_topped_with_artichoke_hummus_and_lamb.jpg

An alternative to PITB.

Tom