Post reply

I need to give a new user all permission to a new Schema

  • September 3, 2009 at 8:31 am

    #209583

    I want the user to be able to do pretty much any thing in the new schema, but only in the schema no where else. so create a table, SP and so on ans so on?

    did a quick search on BOl and the web but could not find what I was looking for.

    THANKS

  • September 3, 2009 at 2:55 pm

    #1049095

    FYI if anyone needs to know this link will help

    http://searchsqlserver.techtarget.com/news/article/0,289142,sid87_gci1102099,00.html

    there is not much help on this out there. but its a good way to give developers a place to play on a server that you dont want to give all access too..

  • September 3, 2009 at 6:09 pm

    #1049159

    It's pretty much a two-step process. First, GRANT CREATE in the database on all the statements (TABLE, PROC, etc.). Second, GRANT ALTER SCHEMA on the schema itself. That should do that.

    Now how to implement... best to create a role and assign the permissions to the role. Then make the appropriate users a member of said database role.

    K. Brian Kelley
    @kbriankelley

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

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