Friday, March 9, 2012

permissions

Hello
I want to give the following permissions to a user:
* Can read sql server tables through Microsoft Access
odbc links, but cannot write using this method
* Can insert, update or delete rows in sql server tables
through stored procedures or an aplicattion
Can I do that? How?
Thanks for your helpJefferson
From BOL
GRANT INSERT, UPDATE, DELETE
ON authors
TO Mary, John, Tom
GO
Also consider using Application Role (for more details please refer to BOL)
"Jefferson" <jeff_cm@.yahoo.com> wrote in message
news:0bb201c37160$5ee5e670$a401280a@.phx.gbl...
> Hello
> I want to give the following permissions to a user:
> * Can read sql server tables through Microsoft Access
> odbc links, but cannot write using this method
> * Can insert, update or delete rows in sql server tables
> through stored procedures or an aplicattion
> Can I do that? How?
> Thanks for your help
>|||If they can read all data, add the users to the
db_datareader role. To insert, update or delete through
stored procedures, just give execute permissions on the
stored procedures only and no insert, update or delete on
the tables. You will need to make sure you maintain
ownership chains as well.
If you want it managed through an application only, you
would want to look at Application Roles.
-Sue
On Tue, 2 Sep 2003 07:42:01 -0700, "Jefferson"
<jeff_cm@.yahoo.com> wrote:
>Hello
>I want to give the following permissions to a user:
> * Can read sql server tables through Microsoft Access
>odbc links, but cannot write using this method
> * Can insert, update or delete rows in sql server tables
>through stored procedures or an aplicattion
>Can I do that? How?
>Thanks for your help

No comments:

Post a Comment