Add Permission Stored Procedure!

microsoft.public.sqlserver.programming

21 Oct 2005 1:25 AM

Adam Knight

Hi all,

Just wondering, is their a system stored procedure i can use to grant
permission to all objects in a specified db to a specified user ?

Cheers,
Adam

21 Oct 2005 2:37 AM

Jerry Spivey

Adam,

What is your goal - read access or modification capability? Might look at
the db_datareader and db_datawriter fixed databse roles.

HTH

Jerry
Show quote

"Adam Knight" <a***@pertrain.com.au> wrote in message
news:%23Xs4Z5d1FHA.1032@TK2MSFTNGP12.phx.gbl...
> Hi all,
>
> Just wondering, is their a system stored procedure i can use to grant
> permission to all objects in a specified db to a specified user ?
>
> Cheers,
> Adam
>

21 Oct 2005 6:08 AM

Jens

Few hours ago:

http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thread/49344927e9915da5

HTH, Jens Suessmeyer.