Post reply

Doesn't security cascade down?

  • January 28, 2011 at 5:02 am

    #1279623

    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.

  • January 28, 2011 at 6:40 am

    #1279670

    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

  • January 28, 2011 at 7:12 am

    #1279690

    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

  • January 28, 2011 at 7:14 am

    #1279694

    PITA

    Pain in the A$$

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

    Greg E

  • January 28, 2011 at 7:21 am

    #1279700

    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

  • January 28, 2011 at 9:39 am

    #1279777

    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

  • January 28, 2011 at 2:14 pm

    #1279953

    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

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

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