Post reply

Setting Up a Database, Login and User

  • January 8, 2009 at 9:07 pm

    #199849

    Hello Again,

    Can you tell me where I can find a cut-and-dry step-by-step procedure that follows through setting up a new Database and Login with users mapped to the Login/Database with roles, schemas, etc?

    In SQL Express?

    Thanks 🙂

  • January 8, 2009 at 9:13 pm

    #923888

    there is an example in this forum post which has my example:

    creates a database and two example roles: one that can create and alter tables, and one that can just read and right the data.

    it creates the logins, then creates users to assign to those logins.

    it has both sql login examples, and windows login examples.

    see if that helps you.

    if you wanted to know how to from the GUI, that's a different question.

    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 8, 2009 at 9:33 pm

    #923894

    Go to Codeplex http://www.codeplex.com/MSFTDBProdSamples

    and down load the sample databases for SQL 2005 as an addition to what you create.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • January 8, 2009 at 9:38 pm

    #923897

    Thanks much Lowell, I'll check it out. And thanks much to you too bitbucket.

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

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