Post reply

User Defined Roles

  • January 10, 2011 at 2:15 pm

    #245159

    Looking for a short article that explains what a user-defined security role is in a database, how to create one and assign rights to it and then users.

    Can cover schemas if you would like.

  • January 10, 2011 at 2:44 pm

    #1271628

    I'd like to take a stab at this one; i've got a lot of examples I post to the forums on the subject.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 11, 2011 at 8:53 am

    #1271923

    Excellent. Don't get too technical, don't use too much T-SQL/BOL style of explanation. Think junior DBA, secretary trained to handle basics, and explain in a simple way what to do and what makes sense.

  • January 11, 2011 at 9:59 am

    #1271957

    Lowell,

    If you want to "continue the tradition" on these short articles, please feel free to use the "SQL Spackle" idea and the quote from "Phil McCraken". I've found it really helps set expectations that these short articles that Steve has been requesting are mostly "single topic" and not meant to be complete solutions by themselves.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

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