Secuirty grant to user  
Author Message
John_d_c





PostPosted: Wed Aug 17 22:44:51 CDT 2005 Top

SQL Server >> Secuirty grant to user

Hi,

I have created a database login that belongs to the public
and db_datareader groups so that it can be used for
running queries for that database.

However, there is new requirement for that particular
login to execute an update statement like:

Update Table1 set Field1 = xxxxxx

I would like to know if I just grant UPDATE right to
Table1 for it OR I have to grant INSERT and SELECT as
well ?

Thanks

SQL Server67  
 
 
Dan





PostPosted: Wed Aug 17 22:44:51 CDT 2005 Top

SQL Server >> Secuirty grant to user Just granting UPDATE permissions on Table1 to the user is sufficient.
SELECT permissions are inherited via the db_datareader role. INSERT and
DELETE will not be allowed.

You might consider creating a role and granting permissions to the role
instead of granting permissions directly to the user. This can simplify
security administration because you can then control permissions via role
membership.

--
Hope this helps.

Dan Guzman
SQL Server MVP



> Hi,
>
> I have created a database login that belongs to the public
> and db_datareader groups so that it can be used for
> running queries for that database.
>
> However, there is new requirement for that particular
> login to execute an update statement like:
>
> Update Table1 set Field1 = xxxxxx
>
> I would like to know if I just grant UPDATE right to
> Table1 for it OR I have to grant INSERT and SELECT as
> well ?
>
> Thanks