User Defined Roles

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Articles Requested » User Defined Roles

User Defined Roles

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Monday, January 10, 2011 2:15 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1045584

Lowell

Posted Monday, January 10, 2011 2:44 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:52 AM
Points: 11,627, Visits: 27,693

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1045588

Steve Jones - SSC Editor

Posted Tuesday, January 11, 2011 8:53 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1045955

Jeff Moden

Posted Tuesday, January 11, 2011 9:59 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:57 PM
Points: 32,906, Visits: 26,790

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1045995

« Prev Topic | Next Topic »

Permissions