Re: User roles/rights
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/27/05
- Next message: Jens Süßmeyer: "Re: Prevent Adminstrator Group Access"
- Previous message: Andy: "User roles/rights"
- In reply to: Andy: "User roles/rights"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 27 May 2005 12:41:08 -0400
You will have to touch each db since they each have their own permissions
unless you are sa. You would create a role on each db and give that role db
reader and writer permissions. Then the easiest way is to create a windows
login on the server that includes each of the users in a single group and
tie it to a user in each db that is assigned to that new role. You can do
all of this programmatically. Look up sp_addrole, sp_adduser etc in
BooksOnLine for more details.
-- Andrew J. Kelly SQL MVP "Andy" <Andy@discussions.microsoft.com> wrote in message news:59537242-69D7-49E6-B331-5801EE2EFA19@microsoft.com... > Hi All, > This may be very basic question. I want to create users with rights to Add > or delete rows in all tables(100's) and 10's of database(They shoud not be > able to drop or create table or diagram or anything else). Is there a easy > way to set this up without going in individual db. Just create a new role > maybe or something ? > Not sure never done this before. > Any help would be great. > > Thanks > Andy
- Next message: Jens Süßmeyer: "Re: Prevent Adminstrator Group Access"
- Previous message: Andy: "User roles/rights"
- In reply to: Andy: "User roles/rights"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
