Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

User Defined Roles Expand / Collapse
Author
Message
Posted Monday, January 10, 2011 2:15 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 9:20 AM
Points: 34,087, Visits: 18,224
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
Posted Monday, January 10, 2011 2:44 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:04 AM
Points: 14,458, Visits: 37,981
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!
Post #1045588
Posted Tuesday, January 11, 2011 8:53 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 9:20 AM
Points: 34,087, Visits: 18,224
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
Posted Tuesday, January 11, 2011 9:59 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 41,233, Visits: 38,545
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."

Helpful Links:
How to post code problems
How to post performance problems
Post #1045995
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse