Re: What's the fastest way to assign role with all read/write/excute permissions?
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 09/24/02
- Next message: Richard Waymire [MS]: "Re: restrict server access by ip address"
- Previous message: Sue Hoegemeier: "Re: Removing Users from Database"
- In reply to: Bruce: "What's the fastest way to assign role with all read/write/excute permissions?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Mon, 23 Sep 2002 20:04:14 -0600
I'm not sure about fastest. One option is to grant the role
execute permissions on stored procedures, user defined
functions (and select on user defined functions) and add the
role to built-in database roles of db_datareader and
db_datawriter.
-Sue
On Mon, 23 Sep 2002 15:24:53 -0700, "Bruce"
<brucecheng@mail.com> wrote:
>What's the fastest way to assign a role with permissions
>to read/write all the tables/views and execuate all the
>stored procedures/user defined functions. But not update
>table structure nor create new stored procedures/functions.
>
>Thanks a lot.
- Next message: Richard Waymire [MS]: "Re: restrict server access by ip address"
- Previous message: Sue Hoegemeier: "Re: Removing Users from Database"
- In reply to: Bruce: "What's the fastest way to assign role with all read/write/excute permissions?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
